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: Sent: Tuesday, August 16, 2005 1:59 PM Subject: Re: French Characters,

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 ide

Re: French Characters, Still no answer

2005-08-16 Thread James Sherwood
- Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: 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

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
ROTECTED]> To: <[EMAIL PROTECTED]> Cc: 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 mysq

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: Sent: Monday, August 15, 2005 1:41 PM Subject: Re: French Characters, Still no answer > Hello. > > You've already got a good answer: > ht

Re: French Characters, Still no answer

2005-08-15 Thread Ace Dimitrievski
TECTED]> > To: "James Sherwood" <[EMAIL PROTECTED]> > Cc: > 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 earli

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: show

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: Sent: Monday, August 15, 2005 2:50 PM Subject:

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