Home » Infrastructure » Linux » German characters are coming (oracle,linux)
German characters are coming [message #398208] Wed, 15 April 2009 12:39 Go to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Hi All,

our database is oracle and Operating System is Linux.

basically the language should come in France. but some times some characters are coming in german language.

below is nls_lang parameter set:
FRENCH_FRANCE.WE8MSWIN1252

WE8ISO8859P1 character set defined in our database.

please suggest why this type of character is coming. appreciate your valuable answer.

Thanks in Advance

Regards
Deepak
Re: German characters are coming [message #398209 is a reply to message #398208] Wed, 15 April 2009 12:49 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Try UTF8 characterset database.

Babu
Re: German characters are coming [message #398214 is a reply to message #398208] Wed, 15 April 2009 13:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As far as I know WE8MSWIN1252 handles german characters.
WE8ISO8859P1 may not.
You should upgrade you database to WE8MSWIN1252 one which can be done with a simple ALTER DATABASE command as WE8MSWIN1252 is a stric superset of WE8ISO8859P1.
Just execute csscan to verify your data.

Regards
Michel
Re: German characters are coming [message #398382 is a reply to message #398214] Thu, 16 April 2009 02:29 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
WE8ISO8859P1 can handle German, too.

Of course one "Character" can not really be in any language.

The character "ü" for example could be German OR Turkish.

And even in a "French Language" System you should still be able to enter German names or cities.

So maybe you should post an example of what "Characters" you mean. Are you talking about Oracle messages maybe?
Re: German characters are coming [message #398477 is a reply to message #398214] Thu, 16 April 2009 06:46 Go to previous messageGo to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Hi,

we are getting this type of character "Jörg" should be "Jörg".

sorry priviously i have given the wrong one.

see the current setting value:

NLS_CHARACTERSET WE8ISO8859P15
NLS_NCHAR_CHARACTERSET AL16UTF16

regards
deepak
Re: German characters are coming [message #398480 is a reply to message #398477] Thu, 16 April 2009 06:50 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Are you sure that
1/ Your client program is able to display your character
2/ Your client set the correct NLS_LANG values?

Regards
Michel
Previous Topic: Can not call rc.loca on startup
Next Topic: Silent Installation continue even if failure
Goto Forum:
  


Current Time: Tue Dec 03 18:19:43 CST 2024