dbTalk Databases Forums  

Oracle and dotnet - code page problem

comp.database.oracle comp.database.oracle


Discuss Oracle and dotnet - code page problem in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mrozik
 
Posts: n/a

Default Oracle and dotnet - code page problem - 08-02-2005 , 06:00 AM






Hi!
I have database with ISO-8859-2 code page set
(POLISH_POLAND.EE8ISO8859P2)
I write a WinForms application which uses
those data (System.Data.OracleClient)
How can I force my application to display
national chracters in proper way (i want user
windows-1250 code page)?


Pawel

Reply With Quote
  #2  
Old   
Matthias Hoys
 
Posts: n/a

Default Re: Oracle and dotnet - code page problem - 08-02-2005 , 09:34 AM







"mrozik" <mrozik.p (AT) bez (DOT) spamu.prosze.interia.pl> wrote

Quote:
Hi!
I have database with ISO-8859-2 code page set
(POLISH_POLAND.EE8ISO8859P2)
I write a WinForms application which uses
those data (System.Data.OracleClient)
How can I force my application to display
national chracters in proper way (i want user
windows-1250 code page)?


Pawel
You should set the Oracle NLS_LANG value in the registry to the same
settings as the client code page, so in your case : POLISH_POLAND.MSWIN1252.
The registry value can be found in
hkey_local_machine\software\oracle\home0\nls_lang

HTH
Matthias Hoys





Reply With Quote
  #3  
Old   
mrozik
 
Posts: n/a

Default Re: Oracle and dotnet - code page problem - 08-04-2005 , 03:06 AM



On Tue, 02 Aug 2005 16:34:36 +0200, Matthias Hoys
<idmwarpzone_NOSPAM_ (AT) yahoo (DOT) com> wrote:

Quote:
"mrozik" <mrozik.p (AT) bez (DOT) spamu.prosze.interia.pl> wrote in message
newsp.suvniej4ytjmp5 (AT) k1013 (DOT) matrixnew.pl...
Hi!
I have database with ISO-8859-2 code page set
(POLISH_POLAND.EE8ISO8859P2)
I write a WinForms application which uses
those data (System.Data.OracleClient)
How can I force my application to display
national chracters in proper way (i want user
windows-1250 code page)?


Pawel

You should set the Oracle NLS_LANG value in the registry to the same
settings as the client code page, so in your case :
POLISH_POLAND.MSWIN1252.
The registry value can be found in
hkey_local_machine\software\oracle\home0\nls_lang

HTH
Matthias Hoys

It was first thing i tried to change :-)
But switching between POLISH_POLAND.EE8ISO8859P2
and POLISH_POLAND.EE8MSWIN1250 charsets has
not influence on that how national characters
appears in .NET windows app...
Pawel





Reply With Quote
  #4  
Old   
Matthias Hoys
 
Posts: n/a

Default Re: Oracle and dotnet - code page problem - 08-04-2005 , 02:20 PM




"mrozik" <mrozik.p (AT) bez (DOT) spamu.prosze.interia.pl> wrote

Quote:
On Tue, 02 Aug 2005 16:34:36 +0200, Matthias Hoys
idmwarpzone_NOSPAM_ (AT) yahoo (DOT) com> wrote:


"mrozik" <mrozik.p (AT) bez (DOT) spamu.prosze.interia.pl> wrote in message
newsp.suvniej4ytjmp5 (AT) k1013 (DOT) matrixnew.pl...
Hi!
I have database with ISO-8859-2 code page set
(POLISH_POLAND.EE8ISO8859P2)
I write a WinForms application which uses
those data (System.Data.OracleClient)
How can I force my application to display
national chracters in proper way (i want user
windows-1250 code page)?


Pawel

You should set the Oracle NLS_LANG value in the registry to the same
settings as the client code page, so in your case :
POLISH_POLAND.MSWIN1252.
The registry value can be found in
hkey_local_machine\software\oracle\home0\nls_lang

HTH
Matthias Hoys


It was first thing i tried to change :-)
But switching between POLISH_POLAND.EE8ISO8859P2
and POLISH_POLAND.EE8MSWIN1250 charsets has
not influence on that how national characters
appears in .NET windows app...
Pawel


And what if you define the system environment variable in your .NET code ?

SET NLS_LANG=POLISH_POLAND.EE8MSWIN1250




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.