Bug #2390 | UCS2 columns have filler bytes after hex-value input | ||
---|---|---|---|
Submitted: | 14 Jan 2004 10:18 | Modified: | 21 Jan 2004 3:38 |
Reporter: | Peter Gulutzan | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.1.2-alpha-debug | OS: | Linux (SuSE 8.2) |
Assigned to: | Alexander Barkov | CPU Architecture: | Any |
[14 Jan 2004 10:18]
Peter Gulutzan
[15 Jan 2004 0:19]
Alexander Barkov
Probably the best choice is to prepend it with a necessary number of 0 digits.
[20 Jan 2004 5:41]
Alexander Barkov
These two are now fixed: SELECT _ucs2 0xAA SELECT _ucs2 X'AA' And automatically extend the argument to 0x00AA
[20 Jan 2004 5:43]
Alexander Barkov
Test with all character types should be done after fixing this: CHAR, VARCHAR and TEXT These two should prepend leding zeros too: CAST(bin_expr AS char character set ucs2) CONVERT(bin_expr using ucs2)
[21 Jan 2004 3:38]
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: Tests were also added.