Categories
Quicksearch
Sponsored Links
Currently...
Reading:
Haruki Murakami: Blind Willow, Sleeping Woman
Listening to:
Moby
(Hotel)
Playing:
Supreme Commander
Watching:
New Tricks
Syndicate This Blog
Powered by
Saturday, February 11. 2006
Unicode strings in MySQL
Here's what I did for the last four hours...
I'm working on my favorite project to make it compatible with MySQL 5.0 (which for some reason has several incompatibilities with the previous version) and I run into a weird bug when inserting Unicode strings. The project supports both Microsoft SQL Server and MySQL, so I use the N'...' syntax to encode Unicode strings.
According to the documentation, that should be fine, but of course it is not. The documentation says that these two statements are equivalent:
SELECT N'some text';
SELECT _utf8'some text';
At least when using Connector/Net, that does not seem to be true. When
inserting values into a UTF8 column, the following statements yield different
results:
INSERT INTO test VALUES (N'\\'); -- inserts two backspaces
INSERT INTO test VALUES (_utf8'\\'); -- inserts only one
Even worse:
INSERT INTO test VALUES (N'Côte d\'Ivoire'); -- syntax error
INSERT INTO test VALUES (_utf8'Côte d\'Ivoire'); -- works
For now I'm waiting to see what the response to my bug report will be - perhaps it's not a bug after all, but a feature...
I'm working on my favorite project to make it compatible with MySQL 5.0 (which for some reason has several incompatibilities with the previous version) and I run into a weird bug when inserting Unicode strings. The project supports both Microsoft SQL Server and MySQL, so I use the N'...' syntax to encode Unicode strings.
According to the documentation, that should be fine, but of course it is not. The documentation says that these two statements are equivalent:
SELECT N'some text';
SELECT _utf8'some text';
inserting values into a UTF8 column, the following statements yield different
results:
INSERT INTO test VALUES (N'\\'); -- inserts two backspaces
INSERT INTO test VALUES (_utf8'\\'); -- inserts only one
INSERT INTO test VALUES (N'Côte d\'Ivoire'); -- syntax error
INSERT INTO test VALUES (_utf8'Côte d\'Ivoire'); -- works
Trackbacks
Trackback specific URI for this entry
No Trackbacks
Sponsors
My del.icio.us
- EVE-Central.com - Trade Finder
- 2d EVEMaps
- Eve[geek]
- navbot - Google Code
- Blue Max - Play the Commodore 64 flight simulator game Blue Max online (released 1983)
- Kokoromi Collective - gamma 256
- Virtual Stable (R) Registration Page
- Ready for Anything : 52 Productivity Principles for Work and Life
- Getting Things Done : The Art of Stress-free Productivity
- Recovery of RAID and LVM2 Volumes | Linux Journal
- [TWEAK] Enable old NVIDIA Control Panel in new ForceWare drivers (>95 series?) - nVision
- LILEKS (James) Gallery of Regrettable Food
- YouTube - How to fold T-Shirt in split seconds
- Welcome to Google Spreadsheets (Limited Test)
- Plasma Pong
