Philip Semanchuk wrote:
>
> Hi everyone,
> I am having a little trouble with searching for Swedish characters. When I
> SELECT using LIKE I get matches that I do not expect. I have created a
> simple test case that is entirely reproduced below. To summarize, I insert
> one row into a single-column table that contains the right square bracket
> character (ASCII 0x5d). When I search for the Swedish letter ö (ISO-8859-1
> 0xf6) I find the row containing the right bracket.
>
> We're running RedHat 7.2 with nothing fancy added in as we're Linux novices
> and just playing around with the system to see how it works. MySQL -V
> produces this:
> mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
>
> Here's my test:
>
> mysql> create database swedish_character_test;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> use swedish_character_test;
> Database changed
> mysql> create table simple (name varchar(255) NOT NULL);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into simple (name) values (']');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> select name from simple where name like '%ö%';
> +------+
> | name |
> +------+
> | ] |
> +------+
> 1 row in set (0.00 sec)
>
> I'd appreciate any help understanding why ö = ] in this case.
>
If I were to take a wild guess I would say that the lower 7 bits of ö
and ] match. Which would mean that this isn't really text, ie 7-bit
ASCII, but really BINARY data. Which means either you need "create
table simple (name varchar(255) BINARY NOT NULL);" or "create table
simple (name tinyblob NOT NULL);"
Give thoses a try.
Jim
--
/"\ ASCII Ribbon Campaign .
\ / - NO HTML/RTF in e-mail .
X - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------
[EMAIL PROTECTED] http://www.FreeBSD.org The Power to Serve
[EMAIL PROTECTED] http://www.TheHousleys.net
[EMAIL PROTECTED] http://www.SimTel.Net
---------------------------------------------------------------------
Progress (n) : What led from smart users in front of dumb terminals to
dumb users in front of smart terminals.
---------------------------------------------------------------------
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
