Sorry, dont know how I missed: http://lists.mysql.com/mysql/187794
The old msql was 4.0 and the new one is 4.1. When we first imported the data the database was in latin1(my mistake) and we put it into production as everything seemed to work fine. We have one site that uses french characters sometimes and they compained 1 week later. By that time it was too late to roll back so now we have this problem. We tried converting the database over to Utf8 but it did not seem to fully work. We can put the french characters in, even from the tomcat server, but when they come back out to the webpage(we have a content management system) they are garbled. One night we did some testing and hooked the tomcat to the old database and everything worked fine with french characters so it has to be the new database. If no one has anymore ideas I think our best route is to dump it, install 4.0 on this server and import it back in. Everything looks ok as far as Utf8 on the tables and such, I feel that we are just missing one key thing that is garbling the characters. Also when we use EMS mysqlmanager to view the data, it is fine, it is only when it comes back to the tomcat server it seems. Thanks for your ideas thus far, James ----- Original Message ----- From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Monday, August 15, 2005 1:41 PM Subject: Re: French Characters, Still no answer > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
