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

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: http://climbtothestars.org/archives/2004/07/18/converting-mysql-database-conten

Re: Character encoding problem

2007-11-07 Thread James Sherwood
erwood" <[EMAIL PROTECTED]> To: 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&q

Re: Character encoding problem

2007-11-07 Thread James Sherwood
erwood" <[EMAIL PROTECTED]> To: 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? --Jam

Re: Character encoding problem

2007-11-07 Thread James Sherwood
ct: 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 show all scre

Re: Character encoding problem

2007-11-07 Thread mysql
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 show all screwed up.. I have read the

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! http://smallbusiness.y