RE: character set of a database

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 5 Jan 2001 13:35:36 -0800
Message-Id: <10732.125905@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0775F.71158C90
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> Sent: vendredi, 5. janvier 2001 12:37
>=20
> Where can you find the characterset of a database?

How about
select parameter, value
from nls_database_parameters
where parameter in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET') ;

> Also, why if you have the nls_date_format=3Dyyyyddmm and query=20
> a date field in
> sqlplus it gives the date as dd-MON-yy?

I would think that in SQL*Plus the date would be shown in the format = defined
in nls_session_parameters.nls_date_format, i.e.

SQL> alter session set nls_date_format =3D 'DD-MON-YYYY' ;

Session altered.

SQL> SELECT SYSDATE FROM DUAL ; SYSDATE

05-JAN-2001 SQL> ALTER SESSION SET NLS_DATE_FORMAT =3D 'DD-MON-YY' ; Session altered.

SQL> SELECT SYSDATE FROM DUAL ; SYSDATE

05-JAN-01 Jacques R. Kilcho=EBr
x8816>=20

------_=_NextPart_001_01C0775F.71158C90
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: character set of a database</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: Ruth Gramolini [<A =
HREF=3D"mailto:rgramolini_at_tax.state.vt.us">mailto:rgramolini_at_tax.state.v=

t.us</A>]</FONT>


<BR><FONT SIZE=3D2>&gt; Sent: vendredi, 5. janvier 2001 12:37</FONT>

 > 
 > Where can you find the characterset of a =
database?


How about
 select parameter, value
 from nls_database_parameters
 where parameter in ('NLS_CHARACTERSET', =
'NLS_NCHAR_CHARACTERSET') ;


> Also, why if you have the =
nls_date_format=3Dyyyyddmm and query 
 > a date field in
 > sqlplus it gives the date as dd-MON-yy?


I would think that in SQL*Plus the date would be =
shown in the format defined in nls_session_parameters.nls_date_format, = i.e.

SQL> alter session set nls_date_format =3D =
'DD-MON-YYYY' ;


Session altered.


SQL> SELECT SYSDATE FROM DUAL ;


SYSDATE
 -----------
 05-JAN-2001


SQL> ALTER SESSION SET NLS_DATE_FORMAT =3D =
'DD-MON-YY' ;


Session altered.


SQL> SELECT SYSDATE FROM DUAL ;


SYSDATE
 ---------
 05-JAN-01


Jacques R. Kilcho=EBr
Received on Fri Jan 05 2001 - 15:35:36 CST