Re: French Characters, Still no answer
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]
Re: French Characters, Still no answer
Hello, I dont think we want to go this route as it was working fine on the 4.0 database on the other server. I also might add that the old server was linux, and the new one is Windows 2000 Server Thanks, James - Original Message - From: Ace Dimitrievski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 6:38 PM Subject: Re: French Characters, Still no answer Im not sure if my experience will be of any help but here it is: I used a database with utf8 as default charset (you can easily set this with mysql administrator) and the columns that I needed to store Macedonian cyrilic characters were varchar. Some letters were stored as ?. When I changed the column type to varbinary I was able to store/retreive all the letters properly. However if you change the type of the columns you cannot use the mysql adminisators backup sql queries to restore a database that contains utf8 characters (at least I failed). Using a PHP script will help. For those that use mySQL with some script language using base64 encoding/decoding funtions for non latin1 letters is the safest way (however you cannot strictly predict the lenght of the encoded string based on the lenght of the plaintext). best regards --- Ace Dimitrievski, research assistant, Faculty of Electrical Engineering Skopje --- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The older version is 4.xx.xx im not sure how to tell. New version is 4.1.12 Thank you, James - Original Message - From: Bruce Dembecki [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 2:50 PM Subject: Re: French Characters, Still no answer Still no answer, perhaps, but ther'es still no question. Per my earlier response... What version of MySQL is the old version you refer to, what version is the new version you refer to? With that information someone here is more likely to be able to tell you something useful... without that you're not likely to get much of a response. Best Regards, Bruce On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: 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 -- 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] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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]
Re: French Characters, Still no answer
Hello. 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. That means that data on the server is ok. Check the values of your character_set_client, character_set_connection and character_set_results variables from Tomcat's application. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html 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. Perform an import so that all fields in your table have an utf8 character set. And tune properly the connection variables. James Sherwood [EMAIL PROTECTED] wrote: 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 -- 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]
Re: French Characters, Still no answer
I think I have found the problem: Doing Select @@character_set_database , results, client and connection it all returns latin1 I tried set character_set_x = utf8; for them all but it did not work, they stayed latin1 and need to be utf8 Any ideas how to change this? Thanks, James - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 16, 2005 11:16 AM Subject: Re: French Characters, Still no answer Hello. 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. That means that data on the server is ok. Check the values of your character_set_client, character_set_connection and character_set_results variables from Tomcat's application. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html 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. Perform an import so that all fields in your table have an utf8 character set. And tune properly the connection variables. James Sherwood [EMAIL PROTECTED] wrote: 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 -- 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]
Re: French Characters, Still no answer
On Tue, 16 Aug 2005, James Sherwood wrote: I think I have found the problem: Doing Select @@character_set_database , results, client and connection it all returns latin1 I tried set character_set_x = utf8; for them all but it did not work, they stayed latin1 and need to be utf8 Any ideas how to change this? Which version of the Conenctor J are you using?, is it the latest? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French Characters, Still no answer
We are using 3.0.9 and the latest is 3.1.10 But we connect to the old 4.0 database fine, would the connector matter? James - Original Message - From: Jason Pyeron [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 16, 2005 1:59 PM Subject: Re: French Characters, Still no answer On Tue, 16 Aug 2005, James Sherwood wrote: I think I have found the problem: Doing Select @@character_set_database , results, client and connection it all returns latin1 I tried set character_set_x = utf8; for them all but it did not work, they stayed latin1 and need to be utf8 Any ideas how to change this? Which version of the Conenctor J are you using?, is it the latest? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- 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]
Re: French Characters, Still no answer
Still no answer, perhaps, but ther'es still no question. Per my earlier response... What version of MySQL is the old version you refer to, what version is the new version you refer to? With that information someone here is more likely to be able to tell you something useful... without that you're not likely to get much of a response. Best Regards, Bruce On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French Characters, Still no answer
The older version is 4.xx.xx im not sure how to tell. New version is 4.1.12 Thank you, James - Original Message - From: Bruce Dembecki [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 2:50 PM Subject: Re: French Characters, Still no answer Still no answer, perhaps, but ther'es still no question. Per my earlier response... What version of MySQL is the old version you refer to, what version is the new version you refer to? With that information someone here is more likely to be able to tell you something useful... without that you're not likely to get much of a response. Best Regards, Bruce On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: 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 -- 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]
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]
Re: French Characters, Still no answer
Im not sure if my experience will be of any help but here it is: I used a database with utf8 as default charset (you can easily set this with mysql administrator) and the columns that I needed to store Macedonian cyrilic characters were varchar. Some letters were stored as ?. When I changed the column type to varbinary I was able to store/retreive all the letters properly. However if you change the type of the columns you cannot use the mysql adminisators backup sql queries to restore a database that contains utf8 characters (at least I failed). Using a PHP script will help. For those that use mySQL with some script language using base64 encoding/decoding funtions for non latin1 letters is the safest way (however you cannot strictly predict the lenght of the encoded string based on the lenght of the plaintext). best regards --- Ace Dimitrievski, research assistant, Faculty of Electrical Engineering Skopje --- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The older version is 4.xx.xx im not sure how to tell. New version is 4.1.12 Thank you, James - Original Message - From: Bruce Dembecki [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 2:50 PM Subject: Re: French Characters, Still no answer Still no answer, perhaps, but ther'es still no question. Per my earlier response... What version of MySQL is the old version you refer to, what version is the new version you refer to? With that information someone here is more likely to be able to tell you something useful... without that you're not likely to get much of a response. Best Regards, Bruce On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: 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 -- 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] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
