I have a database created with collation of latin1_swedish_ci which contains
big5. I realise that I have to create the db using utf8 in order to display
correctly. However, due to the db was created long ago, I could not change it.
Is it possible to do a conversion before the characters are displayed?

default charset of apache is utf-8
connection string is added "useUnicode=true&characterEncoding=UTF-8"

Hi,

Use the http://livedocs.adobe.com/coldfusion...3.html#2962107 tag like this,

<cfprocessingdirective pageencoding=#your_encoding_type#>

I have tried before but does not work.

Pls me provide more information:

the information inputted to database was from a website with charset ="big5".
actually, this website is developed in php.

Now, I want to use CF to display the information from the database. the
website is in utf-8.

The charset in the database should be in big5. I possibly need big5-to-utf8
conversion?

Hi,

Try like this,

<cfcontent type="text/html; charset=big5" reset="no">

dynason wrote:
> I have a database created with collation of latin1_swedish_ci which contains

what "database"? what datatypes?

> big5. I realise that I have to create the db using utf8 in order to display

if the columns holding your text datatypes aren't unicode capable, then you'll
never get the data out except the same way it went in.

depending on the db, datatypes, app server, it's a good bet that the data's not
big5 but some corruption of it.