Bug #6819 Some ujis characters cannot be inserted into table
Submitted: 25 Nov 2004 1:45 Modified: 10 Dec 2004 12:12
Reporter: Shuichi Tamagawa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.7 OS:Linux (SuSE Linux 9.0)
Assigned to: Alexander Barkov CPU Architecture:Any

[25 Nov 2004 1:45] Shuichi Tamagawa
Description:
The code ranges of ujis are 0x21-0x7E, 0xA1A1-0xFEFE, 0x8EA1-0x8EDF, and 0x8FA1A1-0x8FFEFE. However, some characters in these code ranges cannot be inserted into table. Please see the attached file 'list.txt' for the code list of these characters.

How to repeat:
mysql> source test.txt

Suggested fix:
These characters should be inserted as is.
[25 Nov 2004 1:46] Shuichi Tamagawa
Code list of characters which cannot be inserted

Attachment: list.txt (text/plain), 4.97 KiB.

[25 Nov 2004 1:46] Shuichi Tamagawa
Test case

Attachment: test.txt (text/plain), 30.93 KiB.

[25 Nov 2004 6:51] Shuichi Tamagawa
Suggested fix

Attachment: mysql-4.1.7-ctype-ujis.patch (application/octet-stream, text), 802 bytes.

[25 Nov 2004 6:53] Shuichi Tamagawa
I've attached suggested fix by Mr. Masahiro Tomita in japanese user group.
[9 Dec 2004 4:49] Shuichi Tamagawa
Sorry the test case file was wrong.

set names sjis;
set character_set_database = sjis;

should be

set names ujis;
set character_set_database = ujis;
[10 Dec 2004 12:12] Alexander Barkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed in 4.1.8.