Victoria Reznichenko wrote:
> 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)
>
>
if I build mysql with
./configure --with-charset=koi8_ru
then check (make; make check; make test) failed!
But if I build mysql with
./configure --with-extra-charsets=all
and then insert in /etc/my.cfg before mysqld start this strings:
---cut---
[mysqld]
character-sets-dir=/usr/share/mysql/charsets/
default-character-set=koi8_ru
---cut---
then all OK and query "INSERT INTO COUNTRIES VALUES ('Исландия')" not fail!
--
с уважением
Кирилл Злачевский
Don-Link ITSP
WWW : http://www.phone.dn.ua
office: +380 62 3450119, +380 62 3341698, +380 62 3810593
mobile: +380 67 7072937
---------------------------------------------------------------------
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
