Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Character Set
- Thread starter ofsouto
- Start date
Just use the correct character set (at least 8Bit) and the correct national settings.
Your characters seem to be spanish. Then
NLS_LANG = SPANISH_SPAIN.WE8ISO8859P1 will do
If your database is configured like the following:
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
it doesn't matter. It's just that all your clients will be installed using the spanish language (requested when running the installer).
If you already installed your client:
On UNIX: set the users environment variable NLS_LANG, thats it
On Windows: search the registry for NLS_LANG and change the parameter to support your language.
P.S: If you are portuguese (so sorry) then use PORTUGUESE_PORTUGAL instead.
Your characters seem to be spanish. Then
NLS_LANG = SPANISH_SPAIN.WE8ISO8859P1 will do
If your database is configured like the following:
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
it doesn't matter. It's just that all your clients will be installed using the spanish language (requested when running the installer).
If you already installed your client:
On UNIX: set the users environment variable NLS_LANG, thats it
On Windows: search the registry for NLS_LANG and change the parameter to support your language.
P.S: If you are portuguese (so sorry) then use PORTUGUESE_PORTUGAL instead.
- Thread starter
- #3
you were right 
2 nil, not a bad result Mike
________________________________________________________________
"Experience is the comb that Nature gives us, after we are bald."
Is that a haiku?
I never could get the hang
of writing those things.
2 nil, not a bad result Mike________________________________________________________________
"Experience is the comb that Nature gives us, after we are bald."
Is that a haiku?
I never could get the hang
of writing those things.
Oh,
refer to this link:
or
there you will find all parameters and character sets available. Look in Chapter A
In your case I would expect, that you set your Oracle Client to NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8EBCDIC284
refer to this link:
or
there you will find all parameters and character sets available. Look in Chapter A
In your case I would expect, that you set your Oracle Client to NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8EBCDIC284
- Status
Similar threads
- Locked
- Question
- Locked
- Question