charactersets

2007-02-28 Thread Matthias Henze
hi, by now i've used mysql 4.0 now i have to switch to 5.0. my problem is that the old databases are in latin1 and all my php code does not care about character sets as it just used to work ... i was able to load the datat to mysql 5.0 with latin1 encoding. aleast mysql shows latin1 as

Re: charactersets

2007-02-28 Thread Mario Guenterberg
On Wed, Feb 28, 2007 at 09:39:40AM +0100, Matthias Henze wrote: hi, 1. is ist possible to switch mysql 5.0 completely to UTF-8 ? Yes. 2. an option would be to convert my data from latin1 to UTF-8 how can i do this ? Export your 4.x databse with mysqldump and convert it with iconv.

Rplication charactersets bug?

2002-01-28 Thread Lyubomir Simich
Hi I have a two servers: 1. MSATER mySQL 3.23.47 under Windows 2000 character_set: koi8_ru character_sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia