nls_database_parameters->nls_length_semantics Help!
687208Feb 24 2009 — edited Apr 14 2009Hi all!
I have to create a database with the parameter nls_length_semantics set to char but I don't know how to do it!
In a new machine, where was installed only the oracle client(10), I install a new database software (10g), during the installation process I was unable to select the character set.
Then I install the first instance and select AL32utf8 as character set and select length semantics= char.
But the select * from nls_database_parameters shows nls_length_semantics=byte ko
and
select * from nls_instance_parameters shows nls_length_semantics= char ok
how can I do to set both with nls_length_semantics= char?
Yes I will reinstall the database but I do not understand what was wrong?
Thank you for help
Mario