Our site allows international / non-ASCII characters (accents, curly quotes,
etc) in database data. We are using MySQL 4.1.
In CF 6.1, it all works great with the following:
<cfset setEncoding("form","ISO-8859-1")>
<cfset setEncoding("url","ISO-8859-1")>
<cfcontent type = "text/html; charset ISO-8859-1"> AND, using the MySQL 3
driver, useUnicode=true&characterEncoding=ISO-8859-1 in the connection string.
It works.
Now that we've upgraded to CF 8 / the MySQL 4 driver, a lot of our non-ASCII
characters are getting displayed as boxes or other weird characters.
I suspect there is a very simply fix that I'm overlooking here. It appears the
"useUnicode=true&characterEncoding=ISO-8859-1" string used for the MySQL 3
driver is being ignored by the MySQL 4 driver.
Does anyone have any suggestion on how to get this international data to
display properly in CF 8 using the MySQL 4 driver?
Thanks for your thoughts.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294411
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
