Hello.
You've already got a good answer: http://lists.mysql.com/mysql/187794 Subscribe to mysql list or use web interface. Why are you mixing latin1 with utf8 in the same column? You can check if something is wrong with your connection variables using the following statement: show variables like '%char%'; Use mysql command line client or mysql-query-browser (or other client software which correctly handles UTF8 data) to check if import of your data was performed successfully. In such a way you can localize the problem, and find whether it is related to Tomcat or wrong data in MySQL. >I am still having trouble with french characters if anyone has ANY ideas, > please help. > > We have installed the newest version of MySql and cannot get it to play > nice > with French characters. Our older version worked fine. The problem > may (or > may not) be that when we put the dump into the new database(yes its > default > charset is Utf8) the default character set for the table is Utf8 but > some > fields are like this: > > 'Story' longtext character set latin1 NOT NULL > > We tried linking our tomcat to the old database on the other server > through > this tomcat and everything works fine but when we link the tomcat back > to > the new database, it will not play nice with french characters. (they > come > out as outlined squares etc) > > Any ideas would be greatly appreciated > James >"James Sherwood" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]