nls_sort doesn't work on init file 
Author Message
 nls_sort doesn't work on init file

Hi,
I try to set nls_sort to French because it is not case sensitive sorting
( Only sort by alphabetic order, Aa-Zz). It only works when I
use 'alter
session set nls_sort = French' command. It doesn't work when I change
this parameter in Instance Manager or add into initial file to make it
default.  It allow me change nls_sort to French and it shows nls_sort
is French but when I use sort function it still use case sensitive sort
( Sort A-Z then a-z). I want to make 'nls_sort = French' a database
default. Is anybody can help me? Thanks a lot.

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 nls_sort doesn't work on init file



Quote:
>Hi,
>I try to set nls_sort to French because it is not case sensitive sorting
>( Only sort by alphabetic order, Aa-Zz). It only works when I
>use 'alter
>session set nls_sort = French' command. It doesn't work when I change
>this parameter in Instance Manager or add into initial file to make it
>default.  It allow me change nls_sort to French and it shows nls_sort
>is French but when I use sort function it still use case sensitive sort
>( Sort A-Z then a-z). I want to make 'nls_sort = French' a database
>default. Is anybody can help me? Thanks a lot.

>Sent via Deja.com http://www.deja.com/
>Before you buy.

Nls_sort is set by nls_language automatically. You must define that value
when you create the database.

Roblop



Wed, 18 Jun 1902 08:00:00 GMT
 nls_sort doesn't work on init file

Quote:

> Hi,
> I try to set nls_sort to French because it is not case sensitive sorting
> ( Only sort by alphabetic order, Aa-Zz). It only works when I
> use 'alter
> session set nls_sort = French' command. It doesn't work when I change
> this parameter in Instance Manager or add into initial file to make it
> default.  It allow me change nls_sort to French and it shows nls_sort
> is French but when I use sort function it still use case sensitive sort
> ( Sort A-Z then a-z). I want to make 'nls_sort = French' a database
> default. Is anybody can help me? Thanks a lot.

  HI

  You can change it by a environment variable NLS_LANG.

  For instance: NLS_LANG=french_america.we8iso8859p1

  rgrds.

  Kari
  --
 (Mr.) Kari Pannila
      Oracle DBA (OCP)

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoit{*filter*} edest?, se on SPAMmereita varten.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Scheduling DTS doesn't fail but doesn't work

2. ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

3. File - Connection doesn't work

4. Job doesn't work: access denied to flat file (txt)

5. * VSS Diff doesn't work with *.SQL files

6. Template file doesn't work!!!

7. An EXE file doesn't work the same as the original version

8. End of File doesn't seem to work

9. Signed Cabinet file doesn't work !!!

10. Capture Message File for Replication doesn't work

11. File Save -- sometimes works and sometimes doesn't

12. My .exe file doesn't work


 
Powered by phpBB® Forum Software