Subject | about nocase collation |
---|---|
Author | donoteatcarrot |
Post date | 2005-09-04T08:30:09Z |
Hello, I have a problem with collation.
In "http://www.brookstonesystems.com/ibCollate3.html", at "NOCASE
drivers:",
it sais that "For all NOCASE drivers, if upper(f1) = upper(f2) then
f1 = f2."
and a example is given below.
I downloaded the "collate020607.zip" and tested
SELECT Field FROM T WHERE Field = eAf COLLATE EN_UK_NOCASE;
sucessfully.
but
SELECT Field FROM T WHERE Field like e%A%f COLLATE EN_UK_NOCASE;
dose not work.
If I want the nocase collation also work good with "like" statement,
how should I do ?
Any comments or opinions will be very welcomed.
Ryu
In "http://www.brookstonesystems.com/ibCollate3.html", at "NOCASE
drivers:",
it sais that "For all NOCASE drivers, if upper(f1) = upper(f2) then
f1 = f2."
and a example is given below.
I downloaded the "collate020607.zip" and tested
SELECT Field FROM T WHERE Field = eAf COLLATE EN_UK_NOCASE;
sucessfully.
but
SELECT Field FROM T WHERE Field like e%A%f COLLATE EN_UK_NOCASE;
dose not work.
If I want the nocase collation also work good with "like" statement,
how should I do ?
Any comments or opinions will be very welcomed.
Ryu