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-character-set=UTF-8 -uNAME -pXXX mydb
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\charsets\Index' file
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'. The only exception to this is SET
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 Unknown character
set: 'x
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.conflatin1
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 properly translated
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/convert.cc
b
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 test;
??? I get only 34465 byte
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-Repeat:
Setup