Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Informix is unable to keep/process UCS-2 natively. At all.
The problem with UCS-2 / UTF-16 is that for English symbols,
every second symbol is ASCII '0' - end of line symbol
The only way to keep UCS-2 data in Informix is to use the UNICODE
datablade.
In contrast with UCS-2, UTF-8 works perfectly with Informix.
-Alexey
> -----Original Message-----
> From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org] On
> Behalf Of Art S. Kagel
> Sent: Wednesday, January 26, 2005 10:02 AM
> To: informix-list@iiug.org
> Subject: Re: How do i guarantee sorting using UCS-2 character set?
>
> 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
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.