Why it didn’t work out with Rekall (yet)
A couple of days ago I made Rekall work with MySQL on OS X. And now I’m not really using it!
There is a big showstopper for maintaining german content (or in any other language that uses more than the 7 bit ASCII character set): Rekall (on the Mac) doesn’t handle Unicode correctly. Here’s a short sample: to the left the expected display (from phpMyAdmin), to the right the screen shot from Rekall:
 |
 |
What if I entered the umlaut in Rekall? Then phpMyAdmin shows the content as if it wouldn’t know how to display UTF-8 codes:
 |
 |
What happens is that the transformation takes place twice:
- The UTF-8 transformation of ‘ä’ (
0xE4) is ‘ä’ (0xC3 0xA4) as shown in the second phpMyAdmin screen shot. - The UTF-8 transformation of ‘ä’ is
0xC3 0x83 0xC2 0xA4, which is what is stored in the database, as a hexdump shows.
I have seen the same strange glyphs for umlauts in another Mac port of a multi platform program: Perforce P4V in Version 2005.1 has the same problem:
Because Rekall and P4V both are based on the Qt library, I think it’s actually a bug in the Mac port of Qt; I have never used Rekall on other platforms, but I know that the Windows port of the same version of P4V shows the umlaut as expected:
January 6th, 2006 at 16:55
Hello!
It seems to me that all versions of Rekall has this problem as I’ve tested it under Linux (Ubuntu and Mepis) and Windows –although I have problems with spanish characters like Ñ or “tildes”: á.
I’ll keep trying to find the info on how to solve the problem, and if I do I guess i’ll write it here and on any other page that could help others
Bye
January 8th, 2006 at 21:25
Hello KkrodD!
Thanks for your information, you’re welcome to post new facts here.
April 24th, 2006 at 17:33
In addition, knoda (another OS database frontend) has troubles with umlauts as well, although not these problems. I think it might actually be a mysql 4.1 + problem, not something to do with any of these.
April 24th, 2006 at 17:34
Oh, and that’s on linux.