Re: how to store ACELNÓSZZACELNÓSZZ in procedure

On Mar 22, 10:39 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
> On Mar 22, 2:26 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > On Mar 22, 9:23 am, "Steve Robin" <ocma..._at_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