Re: database character set...

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 29 Apr 2004 19:15:30 +1000
Message-ID: <4090c7b8$0$20662$afc38c87@news.optusnet.com.au>

Volker Hetzer wrote:

> Hi!
> How can I figure out the database character set from sqlplus?
> The only place I've found so far is the alert.log.
> (9.2.0.4, Linux RH)
>
> Lots of Thanks!
> Volker

Select * from database_properties.

If memory serves, NLS_NCHAR_CHARACTERSET gives you your National Language character set. And NLS_CHARACTERSET gives you your character set.

Regards
HJR Received on Thu Apr 29 2004 - 04:15:30 CDT

This message: [ Message body ]
Next message: Howard J. Rogers: "Re: delete from a view"
Previous message: Howard J. Rogers: "Re: Maximum number of enabled rows exceeded"
In reply to: Volker Hetzer: "database character set..."
Next in thread: Volker Hetzer: "Re: database character set..."
Reply: Volker Hetzer: "Re: database character set..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US