I found that character is problem, which character set will support
polish characters.
As I found EE8ISO8859P2 does support according to
http://www.wangz.net/nls_ei.php
I still I am not able to store it.
Is there any way to store following characters(polish characters) in
database:

ACELNÓSZZACELNÓSZZ

oracle : 9.2.0.3
os : sun solaris

SQL> select * from v$nls_parameters;

PARAMETER VALUE
----------------------------------------------------------------
-----------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT DD-
MON-RR
NLS_DATE_LANGUAGE
AMERICAN
NLS_CHARACTERSET
EE8ISO8859P2
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-
MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-
MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET
AL16UTF16
NLS_COMP
BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

On Mar 22, 9:23 am, "Steve Robin" <ocma...@gmail.com> wrote:
> I found that character is problem, which character set will support
> polish characters.
> As I found EE8ISO8859P2 does support according tohttp://www.wangz.net/nls_ei.php
> I still I am not able to store it.
> Is there any way to store following characters(polish characters) in
> database:
>
> ACELNÓSZZACELNÓSZZ
>
> oracle : 9.2.0.3
> os : sun solaris
>
> SQL> select * from v$nls_parameters;
>
> PARAMETER VALUE
> ----------------------------------------------------------------
> -----------------------------------
> NLS_LANGUAGE
> AMERICAN
> NLS_TERRITORY
> AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY
> AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CALENDAR
> GREGORIAN
> NLS_DATE_FORMAT DD-
> MON-RR
> NLS_DATE_LANGUAGE
> AMERICAN
> NLS_CHARACTERSET
> EE8ISO8859P2
> NLS_SORT
> BINARY
> NLS_TIME_FORMAT
> HH.MI.SSXFF AM
> NLS_TIMESTAMP_FORMAT DD-
> MON-RR HH.MI.SSXFF AM
> NLS_TIME_TZ_FORMAT
> HH.MI.SSXFF AM TZR
> NLS_TIMESTAMP_TZ_FORMAT DD-
> MON-RR HH.MI.SSXFF AM TZR
> NLS_DUAL_CURRENCY $
> NLS_NCHAR_CHARACTERSET
> AL16UTF16
> NLS_COMP
> BINARY
> NLS_LENGTH_SEMANTICS BYTE
> NLS_NCHAR_CONV_EXCP FALSE

As usual:
Read the docs, read the docs, or Google (which you obviously didn't do
either)
Make sure the *database* characterset supports Polish, and the
characterset of your *client* is set to the *O/S* characterset.
It is all documented!!! Why do you refuse to read documentation, and
dump at least 5 RTFM questions per day here?


--
Sybrand Bakker
Senior Oracle DBA

On Mar 22, 2:26 pm, "sybrandb" <sybra...@gmail.com> wrote:
> On Mar 22, 9:23 am, "Steve Robin" <ocma...@gmail.com> wrote:
>
>
>
>
>
> > I found that character is problem, which character set will support
> > polish characters.
> > As I found EE8ISO8859P2 does support according tohttp://www.wangz.net/nls_ei.php
> > I still I am not able to store it.
> > Is there any way to store following characters(polish characters) in
> > database:
>
> > ACELNÓSZZACELNÓSZZ
>
> > oracle : 9.2.0.3
> > os : sun solaris
>
> > SQL> select * from v$nls_parameters;
>
> > PARAMETER VALUE
> > ----------------------------------------------------------------
> > -----------------------------------
> > NLS_LANGUAGE
> > AMERICAN
> > NLS_TERRITORY
> > AMERICA
> > NLS_CURRENCY $
> > NLS_ISO_CURRENCY
> > AMERICA
> > NLS_NUMERIC_CHARACTERS .,
> > NLS_CALENDAR
> > GREGORIAN
> > NLS_DATE_FORMAT DD-
> > MON-RR
> > NLS_DATE_LANGUAGE
> > AMERICAN
> > NLS_CHARACTERSET
> > EE8ISO8859P2
> > NLS_SORT
> > BINARY
> > NLS_TIME_FORMAT
> > HH.MI.SSXFF AM
> > NLS_TIMESTAMP_FORMAT DD-
> > MON-RR HH.MI.SSXFF AM
> > NLS_TIME_TZ_FORMAT
> > HH.MI.SSXFF AM TZR
> > NLS_TIMESTAMP_TZ_FORMAT DD-
> > MON-RR HH.MI.SSXFF AM TZR
> > NLS_DUAL_CURRENCY $
> > NLS_NCHAR_CHARACTERSET
> > AL16UTF16
> > NLS_COMP
> > BINARY
> > NLS_LENGTH_SEMANTICS BYTE
> > NLS_NCHAR_CONV_EXCP FALSE
>
> As usual:
> Read the docs, read the docs, or Google (which you obviously didn't do
> either)
> Make sure the *database* characterset supports Polish, and the
> characterset of your *client* is set to the *O/S* characterset.
> It is all documented!!! Why do you refuse to read documentation, and
> dump at least 5 RTFM questions per day here?
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

I try to do that myself first.That's why I was able to send previous
link.
according to Metalink also, "EE8MSWIN1250" supports these character,
but it is not. I try that also, that why I ask.
Am I doing any mistake. Please let me is there any way.

On Mar 22, 10:39 am, "Steve Robin" <ocma...@gmail.com> wrote:
> On Mar 22, 2:26 pm, "sybrandb" <sybra...@gmail.com> wrote:
>
>
>
>
>
> > On Mar 22, 9:23 am, "Steve Robin" <ocma...@gmail.com> wrote:
>
> > > I found that character is problem, which character set will support
> > > polish characters.
> > > As I found EE8ISO8859P2 does support according tohttp://www.wangz.net/nls_ei.php
> > > I still I am not able to store it.
> > > Is there any way to store following characters(polish characters) in
> > > database:
>
> > > ACELNÓSZZACELNÓSZZ
>
> > > oracle : 9.2.0.3
> > > os : sun solaris
>
> > > SQL> select * from v$nls_parameters;
>
> > > PARAMETER VALUE
> > > ----------------------------------------------------------------
> > > -----------------------------------
> > > NLS_LANGUAGE
> > > AMERICAN
> > > NLS_TERRITORY
> > > AMERICA
> > > NLS_CURRENCY $
> > > NLS_ISO_CURRENCY
> > > AMERICA
> > > NLS_NUMERIC_CHARACTERS .,
> > > NLS_CALENDAR
> > > GREGORIAN
> > > NLS_DATE_FORMAT DD-
> > > MON-RR
> > > NLS_DATE_LANGUAGE
> > > AMERICAN
> > > NLS_CHARACTERSET
> > > EE8ISO8859P2
> > > NLS_SORT
> > > BINARY
> > > NLS_TIME_FORMAT
> > > HH.MI.SSXFF AM
> > > NLS_TIMESTAMP_FORMAT DD-
> > > MON-RR HH.MI.SSXFF AM
> > > NLS_TIME_TZ_FORMAT
> > > HH.MI.SSXFF AM TZR
> > > NLS_TIMESTAMP_TZ_FORMAT DD-
> > > MON-RR HH.MI.SSXFF AM TZR
> > > NLS_DUAL_CURRENCY $
> > > NLS_NCHAR_CHARACTERSET
> > > AL16UTF16
> > > NLS_COMP
> > > BINARY
> > > NLS_LENGTH_SEMANTICS BYTE
> > > NLS_NCHAR_CONV_EXCP FALSE
>
> > As usual:
> > Read the docs, read the docs, or Google (which you obviously didn't do
> > either)
> > Make sure the *database* characterset supports Polish, and the
> > characterset of your *client* is set to the *O/S* characterset.
> > It is all documented!!! Why do you refuse to read documentation, and
> > dump at least 5 RTFM questions per day here?
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -
>
> > - Show quoted text -
>
> I try to do that myself first.That's why I was able to send previous
> link.
> according to Metalink also, "EE8MSWIN1250" supports these character,
> but it is not. I try that also, that why I ask.
> Am I doing any mistake. Please let me is there any way.- Hide quoted text-
>
> - Show quoted text -

It may be a bit too difficult for you, as it will force you to type
some commands, but I was quite explicit.
I wrote (hint, hint)
Make sure the *database* characterset supports Polish.
So *verify* the database characterset.

--
Sybrand Bakker
Senior Oracle DBA