utf8 characters not displayed correctly

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.

Hi,

Try like this,

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,

Use the "cfprocessingdirective" tag like this,

<cfprocessingdirective pageencoding=#your_encoding_type#>