Re: How to set character set UTF-8 for mysqldump
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> 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 > > How can I do this? > > TIA, > - Manish > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to set character set UTF-8 for mysqldump
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 How can I do this? TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: set character set on MySQL 4.0.18
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'". The only exception to this is "SET CHARACTER SET DEFAULT". I know the character sets I'm trying are installed, even trying to set the default by name does not appear to work. Any suggestions? What you're trying to do is not supported until 4.1.1: http://dev.mysql.com/doc/mysql/en/SET_OPTION.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
set character set on MySQL 4.0.18
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 CHARACTER SET DEFAULT". I know the character sets I'm trying are installed, even trying to set the default by name does not appear to work. Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
set character set
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.conf usa7.conf cp1257.conf estonia.conf hungarian.conf latin2.conf win1250.conf croat.conf german1.conf Index latin5.conf win1251.conf danish.conf greek.confkoi8_ru.confREADME win1251ukr.conf dec8.confhebrew.conf koi8_ukr.conf swe7.conf - but when I enter mysql, I can't change it to any of those charsets. mysql> set character set "danish"; ERROR 1115: Unknown character set: 'danish' mysql> set character set "czech"; ERROR 1115: Unknown character set: 'czech' mysql> set character set "swe7"; ERROR 1115: Unknown character set: 'swe7' mysql> set character set "latin1"; ERROR 1115: Unknown character set: 'latin1' mysql> set character set "win1250"; ERROR 1115: Unknown character set: 'win1250' I have 4.0.20 (compiled by myself) Am I doing something wrong? Btw, when I specify default-character-set = czech in my.cnf, it works! But it works for whole server and that's exactly what I don't need. I need it just for any domains so their owners have to specify some "SET CHARACTER ..." after connection to db is made. Or is there any other workaround for solving this? Need to recode db to "czech" for several domains (db users...) Best regards and thanks for any advice. I am solving this for months :( Roman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[4.0.20] set character set / bug in replication?
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 into latin2 and I get latin2 characters in my_field. On slave I don't, there are still cp1250 characters. I think, although not 100% sure, thas this worked okey in 4.0.18. Any ideas? -- ./ premax ./ [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SET CHARACTER SET DEFAULT is not working in 4.0.12
>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) --with-charset=czech c) --with-extra-charsets=all 2) Start server 3) Insert data in BLOB (for example some image) 4) Execute SET CHARACTER SET cp1250_latin2; 5) Execute SET CHARACTER SET DEFAULT; 6) Get data from BLOB Now data from BLOB will be different from original inserted in 3). It looks like SET CHARACTER SET DEFAULT isn't working (but it works in lastest 3.23). I tested this on 2 different computers with FreeBSD. >Fix: Sorry, don't know. >Submitter-Id: >Originator:petr >Organization: CD-R server s.r.o. >MySQL support: none >Synopsis: SET CHARACTER SET DEFAULT is not working in 4.0.12 >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-4.0.12 (FreeBSD port: mysql-server-4.0.12) >C compiler:2.95.4 >C++ compiler: 2.95.4 >Environment: System: FreeBSD freebsd.k2.kreteni.cz 4.7-RELEASE FreeBSD 4.7-RELEASE #0: Wed Oct 9 15:08:34 GMT 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe -O3 -fno-omit-frame-pointer' CXX='cc' CXXFLAGS='-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 1218496 Oct 9 14:43 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Mar 22 04:04 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 574916 Oct 9 14:43 /usr/lib/libc.so.4 Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-4.0.12' '--with-server-suffix=' '--program-prefix=' '--enable-assembler' '--with-berkeley-db' '--with-charset=czech' '--with-extra-charsets=all' '--prefix=/usr/local' 'i386-portbld-freebsd4.7' 'CFLAGS=-O -pipe -O3 -fno-omit-frame-pointer' 'CXX=cc' 'host_alias=i386-portbld-freebsd4.7' 'build_alias=i386-portbld-freebsd4.7' 'target_alias=i386-portbld-freebsd4.7' 'CC=cc' 'CXXFLAGS=-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SET CHARACTER SET cp1251_koi8 & mediumtext problem?
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;
> OK. I get 100 Kb of '2'.
>
> Select2:
> SET CHARACTER SET cp1251_koi8;
> SELECT field1 FROM test;
> ??? I get only 34465 byte.
>
> I use mysql 3.23.33, 4.0.0-alpha on FreeBSD 4.3, 4.4.
>
> If I use text instead mediumtext Select2 work correctly. But I use string >65 Kb.
> If I use longtext, longblob or mediumblob problem repeat.
>
> Can I use long string with SET CHARACTER SET cp1251_koi8 option?
>
> ---
> Dmitry Grigoryev
Hi!
Thank you for your bug report, which helped us fix the above bug. A
fix will come up in the next 3.23 and 4.0 releases.
This is a patch that fixes a bug in 4.0.1 :
*** ../mysql-4.1/sql/convert.cc Tue Mar 12 19:57:54 2002
--- sql/convert.cc Thu Mar 28 15:36:58 2002
***
*** 466,472
packet->realloc(packet_length+5+length))
return 1;
char *to=(char*) net_store_length((char*) packet->ptr()+packet_length,
! length);
for (const char *end=from+length ; from != end ; from++)
*to++= to_map[(uchar) *from];
--- 456,462
packet->realloc(packet_length+5+length))
return 1;
char *to=(char*) net_store_length((char*) packet->ptr()+packet_length,
! (ulonglong)length);
for (const char *end=from+length ; from != end ; from++)
*to++= to_map[(uchar) *from];
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SET CHARACTER SET cp1251_koi8 & mediumtext problem?
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.
I use mysql 3.23.33, 4.0.0-alpha on FreeBSD 4.3, 4.4.
If I use text instead mediumtext Select2 work correctly. But I use string >65 Kb.
If I use longtext, longblob or mediumblob problem repeat.
Can I use long string with SET CHARACTER SET cp1251_koi8 option?
---
Dmitry Grigoryev
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Bug in replications] "set character set" don't work
>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 replication with master and slave servers
Do with Master server:
set character set cp1251_koi8;
insert into test (test) values ('[text at cp1251 codepage]');
select test from test;
You will see text, recoded from cp1251 to koi8
Do with Slave server:
select test from test;
You will see text, *dosn't* recoded
>Fix:
Binary log on master (I see it with mysqlbinlog) is right:
query "set character set cp1251_koi8" is present. So, problem
with *slave* only.
>Submitter-Id:
>Originator:Pavel Andreew
>Organization: Ekaterinburg Telegraph
>MySQL support: none
>Synopsis: "set character set cp1251_koi8" don't work on slave server
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.47 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.47-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 4 hours 14 min 6 sec
Threads: 2 Questions: 178 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables:
6 Queries per second avg: 0.012
>Environment:
System: Linux collage 2.4.17 #1 Tue Dec 25 12:39:34 YEKT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 äÅË 6 10:31 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root 1171196 äÅË 3 23:07 /lib/libc-2.2.4.so
-rw-r--r--1 root root 2669312 äÅË 3 23:07 /usr/lib/libc.a
-rw-r--r--1 root root 178 äÅË 3 23:07 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid
--enable-thread-safe-client --without-readline
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
--without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
