How do i guarantee sorting using UCS-2 character set?

Hi: How do I sort always in UCS-2 character set. Even if my CHAR and NCHAR column character set is different. Thanks, Irfan

Irfan Bondre wrote: > Hi: > 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. Art S. Kagel

Hi: But Set Collation only effects NCHAR and NVARCHAR data...

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/