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...
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 ?

Irfan.


"Art S. Kagel" <kagel@bloomberg.net> wrote in message
news:41F7B0EC.9090309@bloomberg.net...
> 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

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/