topic Re: OpenVMS Character Set. in Operating System - OpenVMS

OpenVMS Character Set.

Edwin R. van der Kaaij — Mon, 18 Sep 2006 06:57:47 GMT

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

Re: OpenVMS Character Set.

Marc Van den Broeck — Mon, 18 Sep 2006 07:59:49 GMT

Hi,

if defined the logical nls_lang defines the character set.

On our system it shows:

"NLS_LANG" = "AMERICAN_AMERICA.WE8ISO8859P1"

Rgds
Marc

Re: OpenVMS Character Set.

Edwin R. van der Kaaij — Mon, 18 Sep 2006 08:24:55 GMT

Thanks for the info:

All we have is:

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

So, no solution yet :o)

Ed.

Re: OpenVMS Character Set.

Albert Öttl — Mon, 18 Sep 2006 09:09:51 GMT

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