Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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