On Tue, Aug 03, 2004 at 01:11:44PM -0400, Jeremy March wrote: > Is this for Swedish language data? I don't know Swedish so I don't > actually know where u-diaeresis is sorted in Swedish myself, but > according to the source code (in the file: strings/ctype-uca.c) the > u-diaeresis is sorted as an equivalent of "y" in utf8_swedish_ci.
I don't know Swedish either but section 11.3.13 of the manual ( http://dev.mysql.com/doc/mysql/en/Charset-collation-effect.html ) says that it is sorted with y, as you said. > The unicode codepoint for u-diaeresis is 0x00FC and the capital > U-diaeresis is 0x00DC. > > I just tested this with 4.1.4 (from the bk tree) and it worked correctly > for me. My keyboard isn't setup to enter u-diaeresis easily so I > entered it in hex. Try this: Entering it in hex works for me too. So the problem _was_ actually with the values I inserted into the database. What's the best way to actually see what is stored in the database, preferably as hex or something else that a terminal is guaranteed to display correctly? Clearly, what I was doing earlier was not correct. Thanks, Jody > > CREATE TABLE swedish (col char(20) COLLATE utf8_swedish_ci); > > INSERT INTO swedish VALUES (CONVERT(_ucs2 0x004D00FC006C006C00650072 > USING utf8)), ('MySQL'), ('Muffler'), ('MX Systems'); > > SELECT * FROM swedish ORDER BY col; > +------------+ > | col | > +------------+ > | Muffler | > | MX Systems | > | M??ller | > | MySQL | > +------------+ > 4 rows in set (0.00 sec) > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
