OpenVMS Character Set.

[Edwin R. van der Kaaij]

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

[Marc Van den Broeck]

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]

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 · Accepted solution]

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