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

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 26 Jan 2005 10:58:14 +0100
Message-ID: <ct7ph3$mj4$1@news6.zwoll1.ov.home.nl>

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.
>
>
> Thanks,
> Irfan
>
>

Don't know how UCS-2 sorting would be; sorts are binary, or according to a locale setting.
Would all be documented under NLS_SORT parameter on http://tahiti.oracle.com

-- 
Regards,
Frank van Bortel

Received on Wed Jan 26 2005 - 03:58:14 CST

This message: [ Message body ]
Next message: SR: "Import/Export issue on huge database"
Previous message: Frank van Bortel: "Re: Oracle Apps Instances Per server"
In reply to: Irfan Bondre: "How do i guarantee sorting using UCS-2 character set?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US