Mailing List Archive


Back to the month index Back to the list index
Jesper Weissglas (jesper@robot.se)
Thu, 2 Jan 1997 18:19:53 +0100 

Message-Id: <v03010d03aef19d550e25@[194.52.223.22]>
Date: Thu, 2 Jan 1997 18:19:53 +0100
From: Jesper Weissglas <jesper@robot.se>
Subject: [mSQL] 2.0B1 Problems with character case in LIKE

I'm evaluating mSQL 2.0b1 for use on a site that needs to do
case insensitive LIKE's on fields with Swedish characters.
The new CLIKE statement looks promising, but there seems
to be problems even with the normal like and case sensitivity.

This is 2.0b1 compiled with gcc 2.7.2 under HP-UX 9.07

Hoping that the listserver won't schrew up this mail which
contains 8-bit Quoted Printable format....

/jesper

------------------------

mSQL > drop table test1\g
Query OK. 1 row(s) modified or retrieved.

mSQL > create table test1 (test1 char(200))\g
Query OK. 1 row(s) modified or retrieved.

mSQL > insert into test1 (test1) values ('testing åÄö inSIDE mSQL')\g
Query OK. 1 row(s) modified or retrieved.

mSQL > select test1 from test1\g
Query OK. 1 row(s) modified or retrieved.

 +---------------------------------------
 | test1
 +---------------------------------------
 | testing åÄö inSIDE mSQL
 +---------------------------------------

mSQL > select test1 from test1 where test1 like '%in%'\g
Query OK. 1 row(s) modified or retrieved.

 +---------------------------------------
 | test1
 +---------------------------------------
 | testing åÄö inSIDE mSQL
 +---------------------------------------

mSQL > select test1 from test1 where test1 like '%SIDE%'\g
Query OK. 0 row(s) modified or retrieved.

 +---------------------------------------
 | test1
 +---------------------------------------
 +---------------------------------------

mSQL > select test1 from test1 where test1 like '%å%'\g
Query OK. 0 row(s) modified or retrieved.

 +---------------------------------------
 | test1
 +---------------------------------------
 +---------------------------------------

mSQL > select test1 from test1 where test1 like '%Ä%'\g
Query OK. 0 row(s) modified or retrieved.

 +---------------------------------------
 | test1
 +---------------------------------------
 +---------------------------------------

mSQL > select test1 from test1 where test1 like '%ä%'\g
Query OK. 0 row(s) modified or retrieved.

 +---------------------------------------
 | test1
 +---------------------------------------
 +---------------------------------------

mSQL > \q
Bye!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!