Bug #6819 Some ujis characters cannot be inserted into table

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.

Code list of characters which cannot be inserted

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

Test case

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

Suggested fix

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

I've attached suggested fix by Mr. Masahiro Tomita in japanese user group.

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;

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.