Coldfusion MySQL Character Problems

[Donnie]

Has anyone run across problems with MySQL outputing invalid characters
with Coldfusion?

I am having the following problem when trying to output the contents of
a field in a MySQL table:

When I use Coldfusion with MS SQL Server 2000 it outputs: ératé
When I use Coldfusion with MySQL it outputs: ?rat?
When I use PHP with MySQL it outputs: ératé

The MySQL table is Unicode as are my CFCONTENT and setEncoding()
variables. I am running the most recent version of the MyODBC driver and
have looked everywhere for some sort of answer to this problem.

Any ideas?

Thanks,

Donnie

[Donnie]

Anyone?

Donnie wrote:

> Has anyone run across problems with MySQL outputing invalid characters
> with Coldfusion?
>
> I am having the following problem when trying to output the contents of
> a field in a MySQL table:
>
> When I use Coldfusion with MS SQL Server 2000 it outputs: ératé
> When I use Coldfusion with MySQL it outputs: ?rat?
> When I use PHP with MySQL it outputs: ératé
>
> The MySQL table is Unicode as are my CFCONTENT and setEncoding()
> variables. I am running the most recent version of the MyODBC driver and
> have looked everywhere for some sort of answer to this problem.
>
> Any ideas?
>
> Thanks,
>
> Donnie