1828584 Members
2594 Online
109982 Solutions
New Discussion

OpenVMS Character Set.

 
SOLVED
Go to solution
Edwin R. van der Kaaij
Frequent Advisor

OpenVMS Character Set.

Hello All,

Our Project Team is converting From Oracle RdB to Oracle (on AIX). They have asked me what character set is used on OpenVMS (7.3-2).

I answered ASCII / ISO Latin-1. As far as I know this is the default.

Is there a way (lexical?) to determine what character set is running on our system?

Thanks in advance!

Ed van der Kaaij
3 REPLIES 3
Marc Van den Broeck
Trusted Contributor

Re: OpenVMS Character Set.

Hi,

if defined the logical nls_lang defines the character set.

On our system it shows:

"NLS_LANG" = "AMERICAN_AMERICA.WE8ISO8859P1"

Rgds
Marc
Edwin R. van der Kaaij
Frequent Advisor

Re: OpenVMS Character Set.

Thanks for the info:

All we have is:

LDNS18> sh log *lang*
LNM$SYSTEM_TABLE)
"SYS$LANGUAGE" = "ENGLISH"

So, no solution yet :o)

Ed.
Albert Öttl
Advisor
Solution

Re: OpenVMS Character Set.

Hi Ed,
if you want to know which character set is
used in your RDB Database, start sql and
issue a "show character set" command.

Example:
SQL> show character set
Default character set is DEC_MCS
National character set is DEC_MCS
Identifier character set is DEC_MCS
Literal character set is DEC_MCS

Alias RDB$DBHANDLE:
Identifier character set is DEC_MCS
Default character set is DEC_MCS
National character set is DEC_MCS


LG
Albert à ttl