Character encoding problem STILL

2007-11-08 Thread James Sherwood
Hey all, So I decided to start fresh on a test machine just to see if I could get french characters working. These are my steps: Freshly Installed Mysql 5.0.45 Configure the MySql Server now Detailed Configuration Developer Machine Multifunctional Database Online Transaction Processing Enable

Re: Character encoding problem STILL

2007-11-08 Thread Ananda Kumar
Hi James, set these and try again set session collation_database=latin1_swedish_ci; set session character_set_database=latin1; regards anandkl On 11/9/07, James Sherwood [EMAIL PROTECTED] wrote: Hey all, So I decided to start fresh on a test machine just to see if I could get french

Character encoding problem

2007-11-07 Thread James Sherwood
Hello, We are trying to upgrade from 4.0 to 5 and we are not having any luck on the character sets. We need to use French characters for some things. We have tried setting utf8 for everything we can find but the characters still show all screwed up.. I have read the manual regarding all

Re: Character encoding problem

2007-11-07 Thread James Sherwood
Subject: Re: Character encoding problem James Sherwood wrote: Hello, We are trying to upgrade from 4.0 to 5 and we are not having any luck on the character sets. We need to use French characters for some things. We have tried setting utf8 for everything we can find but the characters still

Re: Character encoding problem

2007-11-07 Thread James Sherwood
] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 6:16 PM Subject: Re: Character encoding problem Hello, Thanks for the info, For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted to that I beleive. Is there a way to dump it to utf8? --James - Original

Re: Character encoding problem

2007-11-07 Thread James Sherwood
PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 7:37 PM Subject: Re: Character encoding problem Hello, After I dump the database in and change everything to utf8(or if I try to dump and make them all utf8 on the dump) I get an incorrect string value error when trying to put

Re: Character encoding problem

2007-11-07 Thread mysql
James Sherwood wrote: Hello, Thanks for the info, For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted to that I beleive. Is there a way to dump it to utf8? You can convert it using iconv:

Character Encoding problem

2007-06-19 Thread Shreko
My machine with a good old mysql 4.0 crashed last week, and going trough recovery I ended up with wrong encoding. Right now mysql is on the same version as before the crash, but at one step data was in newer version of mysql (5.0.x) and I think that this problem I have originated there. Basically,

character encoding problem-have read docs and search mailing list -but..

2005-03-15 Thread fredrich
hi, i am migrating a legacy java application. so i am not suppose to change too much things. the problem is that the app store in multiple language such as korean and english. if i load again the new saved data, then korean language will only be like ',???' old data are ok. displayed in

Re: character encoding problem-have read docs and search mailing list -but..

2005-03-15 Thread fredrich
in addition i also need to save and load korean, simplified chinese, traditional chinese, japanese and english in the same record. have any suggestion ? __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site!