1 message in com.mysql.lists.bugsSET CHARACTER SET DEFAULT not working...| From | Sent On | Attachments |
|---|---|---|
| Petr Murmak | 07 Apr 2003 14:30 |
| Subject: | SET CHARACTER SET DEFAULT not working in 4.0.12 |
|---|---|
| From: | Petr Murmak (pe...@cdr.cz) |
| Date: | 04/07/2003 02:30:39 PM |
| List: | com.mysql.lists.bugs |
I sen't this two weeks ago with mysqlbug script but nobody respond, maybe here someone...
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 ro...@builder.freebsdmall.com:/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