Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Collate

Re: Collate

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sat, 01 Feb 2003 18:54:20 GMT
Message-ID: <BA6157DA.8688%markbtownsend@attbi.com>


in article %zU_9.114461$Ui4.3243632_at_news1.telusplanet.net, Jasminder Rai at jasrai_at_canada.com wrote on 2/1/03 10:44 AM:

> Like in MS-SQL Server 2000, is there an equivalent of COLLATE in Oracle
>
> Thank you,
>
> Jasminder
>
>

Without a reference to how you want to use it, it's a bit difficult to be exact, but have a look at NLS_SORT and NLSSORT in the doc - http://tahiti.oracle.com/pls/db92/db92.drilldown?levelnum=2&toplevel=a96540& method=FULL&chapters=0&book=&wildcards=1&preference=&expand_all=&verb=&word= nls_sort#a96540 Received on Sat Feb 01 2003 - 12:54:20 CST

Original text of this message

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