What version of MySQL are you using? Try switching to 4.1 if you aren't using it...
http://www.mysql.com/doc/en/Charset-Unicode.html +-----------------------------------------------+ 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: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:45 PM To: CF-Talk Subject: Charsets when querying db Hello Im having some trouble with querying my db (Mysql on mx), and im getting � replaced by funny characters and all sorts like that. I have a feeling its to do with the character sets the db is returning, and the charset on the page... I tried to change the page charset, but no difference, is there any way of forcing the db to return a charset... Either that or its a problem with cfmx... :) Ryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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

