SET CHARACTER SET DEFAULT not working in 4.0.12

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.=09
>How-To-Repeat:
1) Compile MySQL 4.0.12 with:
a) uncommented #define DEFINE_ALL_CHARACTER_SETS in sql/convert.cc
b) --with-charset=3Dczech
c) --with-extra-charsets=3Dall
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:=09
>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:
=09
System: FreeBSD freebsd.k2.kreteni.cz 4.7-RELEASE FreeBSD 4.7-RELEASE =
#0:
Wed Oct 9
15:08:34 GMT 2002
root@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=3D'cc' CFLAGS=3D'-O -pipe -O3 =
-fno-omit-frame-pointer'
CXX=3D'cc'
CXXFLAGS=3D'-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors
-fno-rtti -fno-exceptions'
LDFLAGS=3D'' ASFLAGS=3D''
LIBC:=20
-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=3D/var/db/mysql'
'--without-debug' '--without-readline'
'--without-bench' '--without-extra-tools' '--with-libwrap' =
'--with-mysqlfs'
'--with-vio'
'--with-low-memory' '--with-comment=3DFreeBSD port: mysql-server-4.0.12'
'--with-server-suffix=3D'
'--program-prefix=3D' '--enable-assembler' '--with-berkeley-db'
'--with-charset=3Dczech'
'--with-extra-charsets=3Dall' '--prefix=3D/usr/local' =
'i386-portbld-freebsd4.7'
'CFLAGS=3D-O
-pipe -O3 -fno-omit-frame-pointer' 'CXX=3Dcc'
'host_alias=3Di386-portbld-freebsd4.7' =
'build_alias=3Di386-portbld-freebsd4.7'
'target_alias=3Di386-portbld-freebsd4.7' 'CC=3Dcc' 'CXXFLAGS=3D-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


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org