From: Michael Widenius
Date: March 18 1999 8:09pm
Subject: =?iso-8859-1?B?bXlzcWwgcmU6IPYg1g==?=
List-Archive: http://lists.mysql.com/mysql/517
Message-Id: <14065.23848.21168.495984@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

>>>>> "Paul" =3D=3D Paul Schwarzl <schwarzl@stripped> writes:

Paul> Thank you!!
Paul> I=B4ll download this next week.
Paul> (I never saw better support like this! Not even commercial.)
Paul> Really great!

monty> Hi!
monty> I have now made MySQL win32 3.22.20 available.
monty> Could you please confirm that this works better ?
monty> Regards,
monty> Monty

Paul> No, it doesnt.   :-(

Paul> My problem again:
Paul> (I used MySQL Administrator and my own VB6-ODBC-API as clients. I=
 dont think
Paul> that the client is the problem)


Paul> Two rows(Name=3DMyField type=3Dvarchar) in a Table (MyTable) cont=
ains
Paul> 1. =D6STA
Paul> 2. =F6sta

Paul> When I try on mysqld win32 3.22.20 (also 3.22.19) on Nt4.0 SP4 ge=
r:

Paul> 1. select Myfield from MyTable where MyField like '=D6%'
Paul> Rsult: =D6STA

Paul> 2. select Myfield from MyTable where MyField like '=F6%'
Paul> Result: =F6sta

Paul> 3. select Myfield from MyTable where MyField like '%sta'
Paul> Result: =D6STA; =F6sta

Paul> 4. select '=D6'=3D'=F6'
Paul> Result: 1

Paul> When I try on mysqld Linux 3.22.20 (also 3.22.19):

Paul> 1. select Myfield from MyTable where MyField like '=D6%'
Paul> Rsult: =D6STA; =F6sta

Paul> 2. select Myfield from MyTable where MyField like '=F6%'
Paul> Result: =F6sta; =F6sta

Paul> 3. select Myfield from MyTable where MyField like '%sta'
Paul> Result: =D6STA; =F6sta

Paul> 4. select '=D6'=3D'=F6'
Paul> Result: 1


Paul> Why gives the win32 version of Mysql other results then the Linux=
 version?

Fix:

isamchk -r \mysql\data\*\*.ISM

The problem is that the indexes in your tables are stored using the old=

(wrong) sort order.

Regards,
Monty