Irfan Bondre wrote:

> But Set Collation only effects NCHAR and NVARCHAR data...
> From Informix GLS user guide
> "The SET COLLATION statement can specify the localized collating
> order of a locale that is different from what DB_LOCALE specifies.
> This localized collation is applied to sorting operations on NCHAR
> and NVARCHAR data types in the same session. Database objects that
> sort NCHAR or NVARCHAR values use the collating order that was in
> effect when the object was created, if this differs from the
> DB_LOCALE setting."
>
> What about CHAR and VARCHAR columns ?


Cast to NCHAR or NVARCHAR before comparing?

I didn't say it was nice - just that it should work.

> "Art S. Kagel" <kagel@bloomberg.net> wrote:
>>Irfan Bondre wrote:
>>>How do I sort always in UCS-2 character set. Even if my CHAR and NCHAR
>>>column character set is different.
>>
>> It's only possible with IDS 9.40+ using the SET COLLATION
>> statement in the session that requires the alternate ordering.
>> SET NO COLLATION reverts the session to default ordering.



--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/