Re: latin1_de with index

2003-03-07 Thread Thomas Spahni
On Thu, 6 Mar 2003, Fabian Schmidt wrote: > Am 05.03.03 schrieb Thomas Spahni: > > > Some words like "Tetraeder" have the combination 'ae' and should be found > > looking for LIKE '%ae%'; surprisingly this works: > > Queries with "LIKE '%...'" can't use the index and work correct. > Unfortunately

Re: latin1_de with index

2003-03-06 Thread Fabian Schmidt
Am 05.03.03 schrieb Thomas Spahni: > Some words like "Tetraeder" have the combination 'ae' and should be found > looking for LIKE '%ae%'; surprisingly this works: Queries with "LIKE '%...'" can't use the index and work correct. Unfortunately this is no option for big tables. Ciao, Fabian Schmi

Re: latin1_de with index

2003-03-05 Thread Thomas Spahni
On Tue, 4 Mar 2003, Fabian Schmidt wrote: > >Description: > A select returns uncomplete results, when querying an indexed > varchar row with latin1_de character set and strings containing umlauts > or 'ß'. > > >How-To-Repeat: > > start MySQL 4.0 with character set latin1_de. > > create table

latin1_de with index

2003-03-04 Thread Fabian Schmidt
Hello, >Description: A select returns uncomplete results, when querying an indexed varchar row with latin1_de character set and strings containing umlauts or 'ß'. >How-To-Repeat: start MySQL 4.0 with character set latin1_de. create table test (word varchar(255) not null default '', inde