how to store ACELNÓSZZACELNÓSZZ in procedure

From: Steve Robin <ocmaman_at_gmail.com>
Date: 22 Mar 2007 01:23:22 -0700
Message-ID: <1174551802.115382.256650@p15g2000hsd.googlegroups.com>

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

Received on Thu Mar 22 2007 - 03:23:22 CDT