List:General Discussion« Previous MessageNext Message »
From:Cyril Zlachevsky Date:September 26 2002 8:30pm
Subject:[bug] koi8-r codepage bug
View as plain text  
Please read following text only with koi8-r codepage!

---cut---
mysql> DROP TABLE IF EXISTS COUNTRIES;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
    -> PRIMARY KEY (Name) );
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO COUNTRIES VALUES ('Ирландия');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO COUNTRIES VALUES ('Исландия');
ERROR 1062: Повторяющееся значение 'Исландия' для
ключа 1

mysql> SELECT * FROM COUNTRIES WHERE Name='Исландия';
+----------+
| Name     |
+----------+
| Ирландия |
+----------+
1 row in set (0.00 sec)
---cut---

About my system:	Red Hat Linux 7.3 with all updates on today
About MySQL server:	3.23.52, build from sources with next params:
---cut---
./configure  --prefix=%{_prefix} --exec-prefix=%{_exec_prefix} 
--bindir=%{_bindir} --datadir=%{_datadir}  --libdir=%{_libdir} --mandir=%{_mandir} 
--infodir=%{_infodir} \
        --without-readline \
        --enable-shared \
        --with-extra-charsets=complex \
        --with-bench \
        --localstatedir=/var/lib/mysql \
        --with-unix-socket-path=/var/lib/mysql/mysql.sock \
        --with-mysqld-user="mysql" \
        --with-extra-charsets=all \
        --with-innodb \
        --with-thread-safe-client \
        --enable-assembler
 ---cut---



Thread
[bug] koi8-r codepage bugCyril Zlachevsky27 Sep
  • re: [bug] koi8-r codepage bugVictoria Reznichenko27 Sep
    • Re: [bug] koi8-r codepage bugCyril Zlachevsky27 Sep
      • re: Re: [bug] koi8-r codepage bugVictoria Reznichenko27 Sep
    • Re: [bug] koi8-r codepage bugCyril Zlachevsky30 Sep
      • re: Re: [bug] koi8-r codepage bugVictoria Reznichenko30 Sep
    • Re: [bug] koi8-r codepage bugCyril Zlachevsky30 Sep