| Bug #8603 | Some character in big5 may not be able to transfer | ||
|---|---|---|---|
| Submitted: | 18 Feb 2005 15:01 | Modified: | 23 Jun 2005 16:57 |
| Reporter: | John Tam | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
| Version: | 4.1.9-standard | OS: | Any (ALL) |
| Assigned to: | CPU Architecture: | Any | |
[18 Feb 2005 15:38]
John Tam
if anyone can read chinese , this url contain all the test for this bug http://phorum.study-area.org/viewtopic.php?t=29686 Thanks a lot.
[19 Feb 2005 21:53]
MySQL Verification Team
HI! Thank you for writting to us. The problem that you are seeing could be caused by terminal that you are using. Can you please send us the hex output from both INSERT and SELECT ?? You can use HEX() function for the purpose. We do not see exactly , in hex, the exact string that is INSERTed and the exact string that is returned.
[28 Feb 2005 6:34]
John Tam
sorry for taking so long to apply u , below is the character select by the hex function ---------------------------------------------- big5 Hex 碁 E7A281 銹 E98AB9 裏 E8A38F 墻 E5A2BB 恒 E68192 粧 E7B2A7 嫺 E5ABBA ---------------------------- these character can't show by the mysql engine if they are in UTF8 , they show correctly, but if we do SET NAMES big5; it will become some error code, thank u for helping
[28 Mar 2005 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[29 Mar 2005 8:52]
Sergei Golubchik
reopened
[1 Apr 2005 23:10]
John Tam
Please refer to the bug 9357 http://bugs.mysql.com/bug.php?id=9357 it'll be fixed in 4.1.11
[23 Jun 2005 16:57]
Aleksey Kishkin
as far as it's already fixed in the current versions, I set status this bugreport as 'closed' [25 Mar 13:49] Alexander Barkov Fixed in 4.1.11 and 5.0.4.
Description: some special characters in chinese traditional big5 may not be able to display, here are those characters, chinese big5 unicode 碁 0xF9D6 0x88CF 銹 0xF9D7 0x92B9 裏 0xF9D8 0x7CA7 墻 0xF9D9 0x58BB 恒 0xF9DA 0x6052 粧 0xF9DB 0x7881 嫺 0xF9DC 0x5AFA How to repeat: we can create a database that using utf8, as below: create table jj (a varchar(255)) ENGINE=MyISAM DEFAULT CHARSET=utf8; then let's insert some data, insert into jj values ('碁..................'); ok, let's see select in utf8, SET NAMES utf8; SET CHARACTER_SET_CLIENT=utf8; SET CHARACTER_SET_RESULTS=utf8; SELECT * FROM jj; -------------------------- This result is correct! Then let's see select in big5, SET NAMES big5; SET CHARACTER_SET_CLIENT=big5; SET CHARACTER_SET_RESULTS=big5; SELECT * FROM jj; -------------------------- This result returns ?........... (can't display the character) Let's see ICONV in Linux(FC3) put the query in a text file: query.txt iconv -c -f big5 -t utf-8 query.txt > query.utf8.txt then, iconv -c -f utf-8 -t big5 query.utf8.txt > query.big5.txt as we can see , iconv works fine, query.txt == query.big5.txt