Unicode Problem in MySQL database

[SilverStrike]

I am using an MySQL database with utf-8 character set. When I check the data
through phpMyAdmin, the data looks fine (I am using hebrew chars). but when I
try quering for the data from a coldfusion page, I get chars that looks more
like thai.

I am using <cfprocessingdirective pageencoding="UTF-8"> in every page of the
application.
And
<cfset setEncoding("URL", "UTF-8")>
<cfset setEncoding("FORM", "UTF-8")>
<cfcontent type="text/html; charset=UTF-8">
In the Application.cfm file.

I even tried using connection string in the DSN configuration. But it didn't
work Any advice, reference to an online resorce or guidance in the right
direction will be very helpful.

Many thanks in advanced,
Silver Strike

[PaulH]

what db driver? what ver of mysql?

[SilverStrike]

I am using MySQL ver. 4.0.18.
I am waiting for a response from the support team regarding the DB driver info

thanks again

[Neculai Macarie]

> I am using MySQL ver. 4.0.18.

> I am waiting for a response from the support team regarding the DB driver

info

As far as I know you'll need MySQL 4.1.x or 5.0.x if you want Unicode
support.

--
<mack />

[SilverStrike]

This is what the MySQL documantations says....

The thing is, that when I view the data with phpMyAdmin, the data looks fine.
So where does the problem comes from? does Coldfusion has a difficulty in
retrieving the data from that version?

Thanks again,

[PaulH]

you can often put in any sort of slop via a db's interface like that. that
doesn't mean its correctly encoded data, it just means the db's interface works
like that. upgrade the db or don't use unicode. and make sure you're using the
JDBC driver, and have applied that unicode option for that mysql DSN.

[SilverStrike]

OK, thanks alot for the answers...
I understand that the solution isn't from the CFML side but from the MySQL side.

:)