GLS Databases
Hello all,
I set up my database to support french sorting order (using DB_LOCALE and
CLIENT_LOCALE, I set them to fr_be.8859-1). I'm using informix 7.24
It work fine for sorting order (F'ron is coming right after Feron).
But, when I execute the following query :
select * from tab1
where ncharcolumn in ('feron')I only get the rows where ncharcolumn = feron. I was expecting
informix to return feron, f'ron and Feron, as written in the GLS guide
(3-28).
Any idea ?
Thanks
Vincent