Linguistic Sorting Not possible with Unicode 2.0??

Article View: comp.databases.oracle.tools

Article #15

Back to comp.databases.oracle.tools Previous Next

#15

From: Ram Pudupet
Date: Wed, 10 Jun 1998 00:00

21 lines
1558 bytes

Help!!
  We are developing an international application that will run against a

Oracle 8 server. A decision has been made to use the Unicode charset
'UTF8' as the db charset. Oracle only supports the UTF-8 flavor of
Unicode encoding which is a multibyte variable width char encoding
scheme.
  In our application, we can set up the NLS_SORT parameter which will
determine the type of sorting we want on our db columns.(NLS_SORT can be

binary or language specific).
  Since we are  going to be using multiple lanuages, we need linguistic
sorting. However Oracle, says that if we use multibyte charsets,
linguistic sorts cannot be used and that we are stuck with binary sorts.

Is there a way out of this mess other than developing our own language
specific sort routines?...
:-<Ram
rpudupet@hotmail.com
rpudupet@earthlink.net

Technical Details

Message-ID: <357F0F25.8B47A6E7@earthlink.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5464,1aac36f753cebc04,start
X-Google-Attributes: gidf5464,public
X-Google-Thread: f99a8,1aac36f753cebc04,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 103117,1aac36f753cebc04,start
X-Google-Attributes: gid103117,public
From: Ram Pudupet <rpudupet@earthlink.net>
Subject: Linguistic Sorting Not possible with Unicode 2.0??
Date: 1998/06/10
Message-ID: <357F0F25.8B47A6E7@earthlink.net>
X-Deja-AN: 361515722
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: EarthLink Network, Inc.
Newsgroups: comp.databases.oracle.tools,cern.oracle.cde,comp.databases.oracle.misc