Re: How to set character set UTF-8 for mysqldump

2005-01-20 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html "Manish" <[EMAIL PROTECTED]> wrote: > How can I set character set as UTF-8 for mysqldump command? > When I try this, I get an error - > > mysqldump --default-char

How to set character set UTF-8 for mysqldump

2005-01-19 Thread Manish
How can I set character set as UTF-8 for mysqldump command? When I try this, I get an error - mysqldump --default-character-set=UTF-8 -uNAME -pXXX mydb> mydb.sql mysqldump: Character set 'UTF-8' is not a compiled character set and is not specified in the 'C:\mys ql\\share\ch

Re: set character set on MySQL 4.0.18

2004-07-27 Thread Paul DuBois
At 12:34 +0100 7/27/04, Chris Wright wrote: I'm having trouble with character set changes on 4.0.18. I have a database that contains text in multiple languages and I need to be able to select the character set on the fly. For some reason "SET CHARACTER SET x" always returns "U

set character set on MySQL 4.0.18

2004-07-27 Thread Chris Wright
I'm having trouble with character set changes on 4.0.18. I have a database that contains text in multiple languages and I need to be able to select the character set on the fly. For some reason "SET CHARACTER SET x" always returns "Unknown character set: 'x'".

set character set

2004-07-11 Thread Outbound
Hello, I am not able to change character set using "set character set". /etc/my.cnf (important parts) [client] character-sets-dir = /usr/local/share/mysql/charsets --- content of that directory: dns:/usr/local/share/mysql/charsets# ls cp1251.conf dos.conf hp8.conf

[4.0.20] set character set / bug in replication?

2004-07-08 Thread Przemyslaw Popielarski
I've got two Linux x86 servers: master and slave, both with MySQL 4.0.20 from the same package. On the master I do: SET CHARACTER SET cp1250_latin2; UPDATE `my_tab` SET `my_field`='my_cp1250_string'; and got this in both master's and slave's log. On master the data is

SET CHARACTER SET DEFAULT is not working in 4.0.12

2003-03-22 Thread petr
>Description: If I change character set mapping with SET CHARACTER SET character_set_name, I can't change it to DEFAULT (ie. disable mapping) with SET CHARACTER SET DEFAULT. >How-To-Repeat: 1) Compile MySQL 4.0.12 with: a) uncommented #define DEFINE_ALL_CHARACTER_SETS in sql

Re: SET CHARACTER SET cp1251_koi8 & mediumtext problem?

2002-03-28 Thread Sinisa Milivojevic
Dmitry Grigoryev writes: > Hello > > I have followed problem: > > Table: > CREATE TABLE test ( > field1 mediumtext > ); > > Insert: > INSERT INTO test VALUES ('222(100 Kb of '2')222'); > > Select1: > SELECT field1 FROM test

SET CHARACTER SET cp1251_koi8 & mediumtext problem?

2002-03-25 Thread Dmitry Grigoryev
Hello I have followed problem: Table: CREATE TABLE test ( field1 mediumtext ); Insert: INSERT INTO test VALUES ('222(100 Kb of '2')222'); Select1: SELECT field1 FROM test; OK. I get 100 Kb of '2'. Select2: SET CHARACTER SET cp1251_koi8; SELECT field1 FROM t

[Bug in replications] "set character set" don't work

2002-01-08 Thread pavel
>Description: Using "set character set cp1251_koi8" before updates insert right data on master server (cp1251 from client recode to koi8 on server), but replication on slave server wrong (data dosn't recode from cp1251 to koi8). >How-To-