Re: oracle language

"Antonio M." <antispam_at_antispam.com> a écrit dans le message de news:3fe87c49$1_3_at_news.arrakis.es...
> i've config country and language as spain, spanish and the result is the
> same.
>
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> escribió en el mensaje
> news:7jpguv8ink9r12ngu9vfrl1jfaikvgj0el_at_4ax.com...
> > On Tue, 23 Dec 2003 16:26:19 +0100, "Antonio M."
> > <antispam_at_antispam.com> wrote:
> >
> > >in my database when insert char 'Ñ' (Spain) in any string column , i see
> > >'?'.
> > >how can i change this configuration?
> > >
> > >thanks for all.
> > >
> > >
> >
> >
> > By creating the database using the correct characterset or set the
> > NLS_LANG env var/ registry value correctly.
> > The charset would need to be ISO8859P15 or MSWIN1252.
> >
> > You can verify the database charset by querying
> > nls_database_parameters
> >
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
>

Could you post the result of the following query:

Select s.parameter param, s.value sess, d.value db from v$nls_parameters s, nls_database_parameters d where d.parameter (+) = s.parameter
  and s.parameter = 'NLS_CHARACTERSET';

I use WE8MSWIN1252 and it works (Oracle 8.1.7 on Windows NT4):

v817>Select s.parameter param, s.value sess, d.value db   2 from v$nls_parameters s, nls_database_parameters d   3 where d.parameter (+) = s.parameter   4 and s.parameter = 'NLS_CHARACTERSET'   5 /

Parameter                     Session                       Database
----------------------------- ----------------------------- -----------------------------
NLS_CHARACTERSET              WE8MSWIN1252                  WE8MSWIN1252

1 ligne sélectionnée.

v817>create table t (col varchar2(10));

Table créée.

v817>insert into t values('Ñ');

1 ligne créée.

v817>select * from t;

COL

1 ligne sélectionnée.

Regards
Michel Cadot Received on Tue Dec 23 2003 - 11:41:01 CST