| Bug #38079 | MySQL QueryBrowser ver 1.2.4 | ||
|---|---|---|---|
| Submitted: | 12 Jul 2008 21:24 | Modified: | 14 Jul 2008 10:08 |
| Reporter: | Yau Lui | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
| Version: | 1.2.4 | OS: | Windows (XP) |
| Assigned to: | CPU Architecture: | Any | |
[14 Jul 2008 10:08]
Susanne Ebrecht
Please don't support two different things in one bug report. The function length() is working correct. You signs are 3 byte signs and length() returns that it has to use 3 byte for them. We are developing new GUI tools called Workbench at the moment. Please, take a look at: http://wb.mysql.com for further informations.
Description: MySQLQuerryBrowser.exe version 1.2.4 1. The function length() does NOT show up blue (reserved word color) in the command window. 2. When used in Charset utf8: select length('易地並'); It returns 9. which is incorrect compared to this: select substr('易地並',2,2); It returns:地並 which is correct. How to repeat: Abnormality is reported above. Observation: length() function reports a single CJK characters as 3 bytes which is the utf-8 internal representation for Chinese characters. length('易地並')=9 is wrong. substr('易地並',2,2)= 地並 is correct. Suggested fix: length() function does not support utf8 character set.