Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
. 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

Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
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

Re: French Characters, Still no answer

2005-08-16 Thread Gleb Paharenko
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

Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
- 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

Re: French Characters, Still no answer

2005-08-16 Thread Jason Pyeron
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

Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
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

Re: French Characters, Still no answer

2005-08-15 Thread Bruce Dembecki
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

Re: French Characters, Still no answer

2005-08-15 Thread James Sherwood
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

Re: French Characters, Still no answer

2005-08-15 Thread Gleb Paharenko
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:

Re: French Characters, Still no answer

2005-08-15 Thread Ace Dimitrievski
@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