Ok, im stuck again with this whole UTF-8 problem. This time outputting the results.
Below is my complete page that i am testing <cfprocessingdirective pageencoding="utf-8"> <cfcontent type="text/html; charset=utf-8"> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body> <cfquery datasource="#dsn#" name="q"> SELECT * FROM cc_languages WHERE langId = '2' </cfquery> <cfoutput> #q.lang_country# </cfoutput> </cftry> </body> </html> This should simply out Ελλάδα, but its not i am getting junk. I am running MySQL 4.1.6, on CFMX 6.1, windowsXP pro Cheers Andy On Thu, 21 Oct 2004 08:57:20 +0100, Andy Jarrett <[EMAIL PROTECTED]> wrote: > Fixed already > > bad, SQL statement, i was too concerned thinking it was a UTF-8 problem. > > Andy > > > > > On Thu, 21 Oct 2004 08:49:30 +0100, Andy Jarrett <[EMAIL PROTECTED]> wrote: > > Hi there, I'm pretty sure this is me being naive. But i am running > > MySQL 4.1.6 and have create a MyIsam table with a UTF-8 character set. > > > > UPDATE cc_languages2 > > lang_coutry = 'Ελλάδα' > > WHERE langId = 2 > > > > When i run the above code in a <cftry> block i get the following error returned > > > > You have an error in your SQL syntax; check the manual that > > corresponds to your MySQL server version for the right syntax to use > > near '= 'Î"λλάδα' WHERE langId = 2 > > > > Do i need to convert the text i am updating before i run the SQL (by > > the way it says Greece in Greek)?? > > > > Cheers > > > > Andy > > www.andyjarrett.co.uk > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54