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---
---------------------------------------------------------------------
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
