Skip to main content
March 1, 2007
Question

Internationalisation

  • March 1, 2007
  • 2 replies
  • 587 views
Hello everybody,

I a testing CFMX7 in Linux environment (Redhat CentOS 4.4)
Linux is a basic US english) version so is CFMX7 (downloaded trial version, I am testing...)
DB is MySQL 3.23 on a remote server (US english), Databases and tables are encoded with french-UTF8 to get the french characters.
But outputted data thru CF queries do not understand special characters and I don't know what I have to do.
Set Locale works fine on Dates but as no effects on characters.
Just have a look at http://montsarrac2.netensia.net/gpec/pays.cfm as an example.

Thanks for your help
Philippe
This topic has been closed for replies.

2 replies

Inspiring
March 1, 2007
phil56b wrote:
> DB is MySQL 3.23 on a remote server (US english), Databases and tables are
> encoded with french-UTF8 to get the french characters.

not a mysql expert, but i don't think that version supports unicode. also what
db driver are you using? it should be JDBC & include

"useUnicode=true&characterEncoding=utf8"

on the url (which you can add via the advanced menu for that dsn).

March 1, 2007
I try to add "useUnicode=true&characterEncoding=utf8" in the connection string
MySQL DB is 4.1.11 but driver included in CFMX admin is for MySQL 3.x
Maybe this is the point.
How can I change the driver ?

Philippe
Inspiring
March 1, 2007
don't quote me on this, but i think for proper utf-8/unicode support you
need MySQL 4+...


--
Azadi Saryev
Sabai-dee.com
Vientiane, Laos
http://www.sabai-dee.com
March 1, 2007
Thanks,
Sorry for the confusion, MySQL Server is 4.1.11-Debian_4sarge7 (3.23 is another one) and it does support UTF.
But on the Coldfusion Admin, the MySQL driver is for 3.x.
By the way, It works but with this character problem