Re: UTF-8 and MySQL

2004-10-22 Thread Andy Jarrett
The connection string worked a treat, cheer Paul On Thu, 21 Oct 2004 22:24:24 +0700, Paul Hastings <[EMAIL PROTECTED]> wrote: > Andy Jarrett wrote: > > first off not really sure mysql supports unicode/utf-8 at all. > > > > > > > good. > > > http://www.w3.org/1999/xhtml"; xml:lang="en"> >

Re: UTF-8 and MySQL

2004-10-21 Thread Paul Hastings
Andy Jarrett wrote: first off not really sure mysql supports unicode/utf-8 at all. > > good. > http://www.w3.org/1999/xhtml"; xml:lang="en"> not good if the page is in greek. > > > waste of time for mx but useful for brain dead spiders, etc. > This should simply out Ελλάδα,

Re: UTF-8 and MySQL

2004-10-21 Thread Andy Jarrett
Ok, im stuck again with this whole UTF-8 problem. This time outputting the results. Below is my complete page that i am testing http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd";> http://www.w3.org/1999/xhtml"; xml:lang="en"> SELECT * FROM cc_languages

Re: UTF-8 and MySQL

2004-10-21 Thread Andy Jarrett
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

UTF-8 and MySQL

2004-10-21 Thread Andy Jarrett
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 block i get the following error returned You have an error in y