Cyril,
Thursday, September 26, 2002, 11:30:39 PM, you wrote:
CZ> ---cut---
mysql> DROP TABLE IF EXISTS COUNTRIES;
CZ> Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
CZ> -> PRIMARY KEY (Name) );
CZ> Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO COUNTRIES VALUES ('Ирландия');
CZ> Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COUNTRIES VALUES ('Исландия');
CZ> ERROR 1062: Повторяющееся значение 'Исландия' для ключа 1
mysql> SELECT * FROM COUNTRIES WHERE Name='Исландия';
CZ> +----------+
CZ> | Name |
CZ> +----------+
CZ> | Ирландия |
CZ> +----------+
CZ> 1 row in set (0.00 sec)
CZ> ---cut---
I tested your example with koi8_ru and it worked perfectly well for me
mysql> DROP TABLE IF EXISTS COUNTRIES;
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
-> PRIMARY KEY (Name) );
Query OK, 0 rows affected (0.04 sec)
mysql> INSERT INTO COUNTRIES VALUES ('Ирландия');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COUNTRIES VALUES ('Исландия');
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM COUNTRIES WHERE Name='Исландия';
+----------+
| Name |
+----------+
| Исландия |
+----------+
1 row in set (0.00 sec)
mysql> show variables like "char%";
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value
|
| |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| character_set | koi8_ru
|
| |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos
|german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian
|koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
