>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
