Re: [ADMIN] Case insensitive

[Armin Diehl]

Hi,

of cause that works, but what if we need a case incensitive primary key, the 
example ist very slow if you have a lot of records. Is that possible ?

> > select * from userdata wher name = 'John'
> > 
> > select * from userdata wher name = 'joHN'
> > 
> > will fetch me the same results.
> 
> select * from userdata where lower(name) = 'john'
---
[EMAIL PROTECTED]
http://www.net-connection.de
http://www.tradenet32.de