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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182147 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
