| Author |
Oracle and dotnet - code page problem
|
|
| mrozik 2005-08-02, 7:24 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
| |
| Matthias Hoys 2005-08-02, 9:24 am |
|
"mrozik" <mrozik.p@bez.spamu.prosze.interia.pl> wrote in message
news:op. suvniej4ytjmp5@k1013
.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\s
oftware\oracle\home0
\nls_lang
HTH
Matthias Hoys
| |
| mrozik 2005-08-04, 3:25 am |
| On Tue, 02 Aug 2005 16:34:36 +0200, Matthias Hoys
< idmwarpzone_NOSPAM_@
yahoo.com> wrote:
>
> "mrozik" <mrozik.p@bez.spamu.prosze.interia.pl> wrote in message
> news:op. suvniej4ytjmp5@k1013
.matrixnew.pl...
>
> 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\s
oftware\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
| |
| Matthias Hoys 2005-08-04, 8:25 pm |
|
"mrozik" <mrozik.p@bez.spamu.prosze.interia.pl> wrote in message
news:op. suy4s9g8ytjmp5@k1013
.matrixnew.pl...
> On Tue, 02 Aug 2005 16:34:36 +0200, Matthias Hoys
> < idmwarpzone_NOSPAM_@
yahoo.com> wrote:
>
>
> 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_POLA
ND.EE8MSWIN1250
|
|
|
|