Victoria,
I see the problem is with sql/share/charsets/latin1.conf
because German umlaut 'ü' and 'Ü' is mapped to 59 'Y' in the
sort_order array. This is very much unlike the treatment
for the other umlauts ('ä' --> 5C and 'ö' --> 5D)
german1.conf does map 'ü' --> 55 'U' giving a correct sort order (ü == u
for sorting) but then LIKE does not distinguish between 'schwül' and
'schwul' which have a completely different meaning.
I did not yet check for latin1_de.
Here is a diff to make latin1 work for German but I don't know what it
breaks for other languages (anyone else using 'ü' ???):
--- latin1.conf.ori Tue Jul 16 16:37:05 2002
+++ latin1.conf Tue Jul 16 17:14:39 2002
@@ -58,17 +58,17 @@
# sort_order array (must have 256 elements)
00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F
60 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
50 51 52 53 54 55 56 57 58 59 5A 7B 7C 7D 7E 7F
80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
41 41 41 41 5C 5B 5C 43 45 45 45 45 49 49 49 49
- 44 4E 4F 4F 4F 4F 5D D7 D8 55 55 55 59 59 DE DF
+ 44 4E 4F 4F 4F 4F 5D D7 D8 55 55 55 5E 59 DE DF
41 41 41 41 5C 5B 5C 43 45 45 45 45 49 49 49 49
- 44 4E 4F 4F 4F 4F 5D F7 D8 55 55 55 59 59 DE FF
+ 44 4E 4F 4F 4F 4F 5D F7 D8 55 55 55 5E 59 DE FF
Regards,
Thomas
On Thu, 11 Jul 2002, Victoria Reznichenko wrote:
> Thomas,
> Wednesday, July 10, 2002, 3:40:40 PM, you wrote:
>
> TS> On Wed, 10 Jul 2002, Victoria Reznichenko wrote:
>
> >> oliver,
> >> Wednesday, July 10, 2002, 2:33:06 AM, you wrote:
> >>
> >> >>Description:
> >> o> I was trying to find every row in a table which contains the umlaut
> >> o> ü (ue). MySQL listed every row which contained the umlaut and rows
> >> o> which contained the letter y, but no umlaut... Client and server
> >> o> characterset is latin1.
> >>
> >> As far as I understand you want to enable correct German sorting order?
> >> If so, since 4.0.0. MySQL supports latin_de character set.
> >> http://www.mysql.com/doc/G/e/German_character_set.html
>
> TS> Hi Victoria,
>
> TS> unfortunately this is not about sort order but appears to be a bug. I
> TS> checked it with 4.0.2 using charset latin1 and indeed, Oliver's results
> TS> are reproducible. We don't want a hit on 'y' when we search for
> TS> LIKE '%ü%'.
>
> Tomas, character set influence the result of LIKE operator.
> latin1 character set supports only some umlauts. Can you test it with
> charsets for german language, german1 or latin_de?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
