Coldfusion 9 not showing some chinese characters

[MusheerAhmad]

We had web based application made in coldfusion 5 hosted on windows 2000 server. Now we have migrated our application on Coldfusion 9 and windows 2003 server. The problem we are facing is that some chinese characters are showing incorrectly on application pages. we have tried installing language pack and also there is no issue with browser.

Can anybody help us in this regard? Thanks in advance.

[MusheerAhmad]

also i would like to add that we are using utf-8 character encoding on IE.

[Adam Cameron.]

Is this text in your CFM files or coming from your DB?

If they're in the source code, you'll need to make sure the files are saved as UTF-8, and it's probably also a good idea to put a <cfprocessingdirective pageencoding="UTF-8"> at the top of the templates too.

If it's in the DB, make sure the datasource is configured to deal with UTF-8.

--

Adam

[MusheerAhmad]

It is in the data source. And the data source is ms access. We have just copied the database from previous server to the new one.

[tooMuchTrouble]

craptastic, the forums ate my whole posting because of a stray quoted email marker. this posting was supposed to be:

first off, you need to use the access for unicode driver. secondly, cf5 didn't 
know unicode from a hole in the ground & the only way for it use unicode or any 
non-latin-1 page encoding is by basically garbaging the data as far as any 
unicode compliant application goes (cf6 & above). if you still have the cf5 
server, write some cf pages to extract the data from the access db then 
re-import it on the cf 9 server.  finally, access? really?

[Charlie Arehart]

Since you say you moved from CF5 to 9, note that CF6 added a new optional datasource driver for MS Access (when adding the datasource). Try choosing "Microsoft Access with Unicode" rather than what you may have, just "Microsoft Access" (or "ODBC Socket").

Let us know if that helps.

/charlie

[MusheerAhmad]

Hi Charlie,

Already tried that. We're in a fix.. What are we missing??  Please suggest!!

[MusheerAhmad]

Actually we have tried with all the 3.. But to no avail..

[Charlie Arehart]

I'm afraid I have no other thoughts to share. Sorry.

/charlie