Unicode Data and Database

[Yadish]

Dear Friends,

I have a database which contains records in Unicode format. I access my this
database (which is MS Access database) in ASP by using following method:
<%=Server.HTMLEncode(oRs.Fields("field name").Value)%>
This works fine but when I use CFML It just shows ???? (question marks). Let
me know what should I do?

Regards,

Amanat

[Yadish]

Dear Friends,

I have a database which contains records in Unicode format. I access my this
database (which is MS Access database) in ASP by using following method:
<%=Server.HTMLEncode(oRs.Fields("field name").Value)%>
This works fine but when I use CFML It just shows ???? (question marks). Let
me know what should I do?

Regards,

Amanat

[PaulH]

tried the access for unicode driver?

[mxstu]

See [url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=103990[/url]

[Yadish]

How I can use it? I mean what is unicode driver for Access?

Regards,

[PaulH]

it is what it says, a unicode capable driver for access. assuming you're using
cf 6 and above: if you control your server, change the driver for that DSN to
"access for unicode" (it's listed in the drivers) via cfadmin. if not, tell who
ever does to do that for you.

to short circuit the inevitable follow-up: what program did you use to enter
the data? what encoding did you use to enter the data? what encoding are you
using in your cf application?