Query cache and queries with non-english characters

2004-02-29 Thread G B U
Just to be sure that this question is not supressed here :) Recently I've come around that mysql (4.1.0 at least) treats different queries containing non-english characters (in my case characters from cp1251 charset) as the same query and therefore returns wrong results. For example the following

Query cache and queries with non-english characters

2004-02-28 Thread G B U
Recently I've come around that mysql (4.1.0 at least) treats different queries containing non-english characters (in my case characters from cp1251 charset) as the same query and therefore returns wrong results. For example the following queries are regarded as identical while they are not: SELECT

Incompatibility: FreeBSD+MySQL 4.1.0+InnoDB+Spatial Extensions

2003-09-29 Thread G B U
Hi It seems to me that combination from the subject just doesn't work. Every time I try to incorporate spatial column into Innodb table Mysql dies. The simplest case, easy to repeat is bellow. When I'm trying to create table with just one spatial column I'm getting following error: mysql

Re: Incompatibility: FreeBSD+MySQL 4.1.0+InnoDB+Spatial Extensions

2003-09-29 Thread G B U
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote: G B U [EMAIL PROTECTED] wrote: It seems to me that combination from the subject just doesn't work. Every time I try to incorporate spatial column into Innodb table Mysql dies. The simplest case, easy to repeat is bellow. When I'm

Re: Incompatibility: FreeBSD+MySQL 4.1.0+InnoDB+Spatial Extensions

2003-09-29 Thread G B U
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote: Hmm... am I missing something?! IIRC there is nothing manual about Innodb not supporting spatial extensions. And on windows it seems that all is working fine. This is from my Win2000 box with the same Mysql version: mysql