Re: [bug] koi8-r codepage bug
Victoria Reznichenko wrote:
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses latin1 character set and you have compiled only
with koi8_ru.
but if compile MySQL with
./configure --with-charset=koi8_ru --with-extra-charsets=all
check (make; make check; make test) failed too!
That's right?
CZ But if I build mysql with
CZ ./configure --with-extra-charsets=all
CZ and then insert in /etc/my.cfg before mysqld start this strings:
CZ ---cut---
CZ [mysqld]
CZ character-sets-dir=/usr/share/mysql/charsets/
CZ default-character-set=koi8_ru
CZ ---cut---
CZ then all OK and query INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ') not fail!
That's right.
-
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
re: Re: [bug] koi8-r codepage bug
Cyril, Monday, September 30, 2002, 3:35:40 PM, you wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with koi8_ru. CZ but if compile MySQL with CZ ./configure --with-charset=koi8_ru --with-extra-charsets=all CZ check (make; make check; make test) failed too! CZ That's right? The short answer - nope. -- 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
Re: [bug] koi8-r codepage bug
Victoria Reznichenko wrote: Cyril, Monday, September 30, 2002, 3:35:40 PM, you wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with koi8_ru. CZ but if compile MySQL with CZ ./configure --with-charset=koi8_ru --with-extra-charsets=all CZ check (make; make check; make test) failed too! CZ That's right? The short answer - nope. this is bug or feature? ---cut--- # make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases 020930 17:18:52 ../sql/mysqld: Shutdown Complete Installing Slave Databases 020930 17:18:52 ../sql/mysqld: Shutdown Complete Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.07 0.02 0.12 [ pass ] alter_table 0.00 0.02 0.07 [ pass ] analyse 0.01 0.02 0.03 [ pass ] auto_increment0.03 0.01 0.05 [ pass ] backup0.02 0.02 0.04 [ pass ] bdb-crash 0.02 0.01 0.03 [ pass ] bdb-deadlock [ skipped ] bdb [ skipped ] bench_count_distinct 0.03 0.00 0.06 [ pass ] bigint0.03 0.00 0.03 [ pass ] binary [ fail ] Error at line 34: Result length mismatch Below are the diffs between actual and expected results: --- *** r/binary.result Wed Aug 14 01:24:51 2002 --- r/binary.reject Mon Sep 30 17:18:55 2002 *** *** 1,13 name - å ä ö concat(*,name,*) - *å* *ä* *ö* min(name) min(concat(*,name,*)) max(name) max(concat(*,name,*)) ! å *å* ö *ö* name ä å --- 1,13 name ä + å ö concat(*,name,*) *ä* + *å* *ö* min(name) min(concat(*,name,*)) max(name) max(concat(*,name,*)) ! ä *ä* ö *ö* name ä å *** *** 20,25 --- 20,26 ä *ä* ö *ö* name ä + å ö name ä --- Please follow the instructions outlined at http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished make: *** [test] Error 1 ---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
Re: [bug] koi8-r codepage bug
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
re: Re: [bug] koi8-r codepage bug
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses latin1 character set and you have compiled only
with koi8_ru.
CZ But if I build mysql with
CZ ./configure --with-extra-charsets=all
CZ and then insert in /etc/my.cfg before mysqld start this strings:
CZ ---cut---
CZ [mysqld]
CZ character-sets-dir=/usr/share/mysql/charsets/
CZ default-character-set=koi8_ru
CZ ---cut---
CZ then all OK and query INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ') not fail!
That's right.
--
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
[bug] koi8-r codepage bug
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
