关于字符集问题(NLS)

[复制链接]
查看11 | 回复0 | 2005-2-28 12:57:00 | 显示全部楼层 |阅读模式
SELECT *FROM V$NLS_PARAMETERS
PARAMETER
VALUE
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
AMERICAN
NLS_CHARACTERSET
ZHS16GBK
NLS_SORT
BINARY
NLS_NCHAR_CHARACTERSET
ZHS16GBK
SELECT * FROM SYS.NLS_DATABASE_PARAMETERS
PARAMETER
VALUE
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-YY
NLS_DATE_LANGUAGE
AMERICAN
NLS_CHARACTERSET
ZHS16CGB231280
NLS_SORT
BINARY
NLS_NCHAR_CHARACTERSET
ZHS16CGB231280
NLS_RDBMS_VERSION
8.0.5.1.0
SELECT * FROM SYS.PROPS$

NAME
VALUE$
COMMENT$
DICT.BASE
2
dictionary base tables version #
NLS_LANGUAGE
AMERICAN
Language
NLS_TERRITORY
AMERICA
Territory
NLS_CURRENCY
$
Local currency
NLS_ISO_CURRENCY
AMERICA
ISO currency
NLS_NUMERIC_CHARACTERS
.,
Numeric characters
NLS_CALENDAR
GREGORIAN
Calendar system
NLS_DATE_FORMAT
DD-MON-YY
Date format
NLS_DATE_LANGUAGE
AMERICAN
Date language
NLS_CHARACTERSET
ZHS16CGB231280
Character set
NLS_SORT
BINARY
Linguistic definition
NLS_NCHAR_CHARACTERSET
ZHS16CGB231280
NCHAR Character set
NLS_RDBMS_VERSION
8.0.5.1.0
RDBMS version for NLS parameters
GLOBAL_DB_NAME
PROD.WORLD
Global database name
EXPORT_VIEWS_VERSION
7
Export views revision #
上面的语句说明字符集出现了变化,但是大家谁知道怎样才可以改变字符集合,又怎样可以把字符集改回来,
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行