Subject | CONTAINING case insensitive? |
---|---|
Author | skander_sp |
Post date | 2005-12-23T14:30:14Z |
Hello all!
select name
from customer
where name containing 'maria';
Ok, Ok... it return all names containing 'maria', but also 'MARIA',
'Maria' and other uper lower combinations... all fine.
But i'm using a database with DEFAULT CHARACTER SET ISO8859_1 (in this
case I use 'collation es_es')
then I hope it return too 'MarĂa' , but international character (in
other way evaluated correctly for order) cant be evaluates here as 'I'.
Exists some way to get this values also?
tks in advance, all light will be welcomed!
Alejandro
select name
from customer
where name containing 'maria';
Ok, Ok... it return all names containing 'maria', but also 'MARIA',
'Maria' and other uper lower combinations... all fine.
But i'm using a database with DEFAULT CHARACTER SET ISO8859_1 (in this
case I use 'collation es_es')
then I hope it return too 'MarĂa' , but international character (in
other way evaluated correctly for order) cant be evaluates here as 'I'.
Exists some way to get this values also?
tks in advance, all light will be welcomed!
Alejandro