>Description:
The UTF-8 encoding for capital swedish characters ae aa and oe doesn't work. Some
cyrillic
characters doesn't work either. A lot of other utf-encoded characters work so the
settings
are not wrong.
It seems like mysql looses some information when it stores these characters.
At first I thought it was something wrong with the Java JDBC-driver but when I got the
exact same problem using the mysql-terminal client I concluded there must be something
wrong with the server.
>How-To-Repeat:
Set the server in UTF-8 mode. Try to insert "Orebro" (with the correct
spelling) in a table
and
try to retrieve it back. It doesn't work. The second byte in the two byte
sequence representing oe changes and makes the whole character unreadable.
I'm sending an attachment in a separate e-mail (jpg-screenshots)
>Fix:
Insert "orebro" with a non-capital oe in the beginning and it will work. It's
not
quite allright though since some cyrillic characters suffers the same problem.
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization:
pi.se AB
Karlavagen 8
Stockholm
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: UTF-8 representation problem with certain characters
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.0-alpha-standard (Official MySQL-standard binary)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for pc-linux
>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 4.1.0-alpha-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 15 hours 58 min 0 sec
Threads: 4 Questions: 22230 Slow queries: 0 Opens: 28 Flush tables: 1 Open
tables: 22 Queries per second avg: 0.387
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux paros.tourmatch.se 2.4.20 #3 SMP ons maj 7 13:25:44 CEST 2003 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 20011002 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2
-mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Aug 11 21:01 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x 1 root root 1153784 Apr 8 15:01 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2391002 Apr 8 15:02 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 8 15:02 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Aug 16 17:02 /usr/lib/libc-client.a ->
c-client.a
lrwxrwxrwx 1 root root 19 Aug 16 17:02 /usr/lib/libc-client.so ->
libc-client.so.2001
-rw-r--r-- 1 root root 716080 Jan 13 2002 /usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro'
'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
