My mistake, I was reading up on the differences in unicode handling between 4.0 and 4.1 and I had 4.1 on my mind.
Jochem is correct, you would not want to use 4.1. Good lookin' out, Jochem! +-----------------------------------------------+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:16 PM To: CF-Talk Subject: Re: Charsets when querying db Bryan Love wrote: > What version of MySQL are you using? Try switching to 4.1 if you aren't > using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=true&characterEncoding=iso-8859-1 Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4