Re: NLS_LENGTH_SEMANTICS setup does work..

Gaetan Poitras wrote:
> Hi, i need to set the NLS_LENGTH_SEMANTICS parameter to CHAR on oracle
> 9i windows XP.
>
> When I add the NLS_LENGTH_SEMANTICS = 'CHAR' in init.ora
> or if I add it in Regedit or if I do an alter system set
> nls_length_semantics = 'CHAR' I am still in BYTE
>
> select * from nls_database_parameters give me BYTE allways even if the
> alter is done for char..!
>
> All help will be appreciate.. what I did wrong..?
> My NLS_NCHAR_CHARACTERSET = AL16UTF16

You did read the docs?

Greetings!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"