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