storing_chinese

View All Scripts Login to Run Script

Script Name storing_chinese
Description creating a table using both nvarchar and varchar2 columns for storing chinese data
Area SQL General
Contributor That Jeff Smith (Oracle)
Created Thursday April 19, 2018

Statement 1

select * 
from database_properties 
where PROPERTY_NAME in 
   ('NLS_CHARACTERSET', 
    'NLS_NCHAR_CHARACTERSET')


PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
NLS_CHARACTERSET AL32UTF8 Character set

2 rows selected.

PROPERTY_NAME	PROPERTY_VALUE	DESCRIPTION
NLS_NCHAR_CHARACTERSET	AL16UTF16	NCHAR Character set
NLS_CHARACTERSET	AL32UTF8	Character set

Statement 2

CREATE TABLE SO_CHINESE ( value1 NVARCHAR2(20), value2 varchar2(20 char))

Table created.

Statement 3

INSERT INTO SO_CHINESE VALUES (N'玄真', '我很高興谷歌翻譯。' )

1 row(s) inserted.

Statement 4

select * from SO_CHINESE


VALUE1 VALUE2
玄真 我很高興谷歌翻譯。

VALUE1	VALUE2
玄真	我很高興谷歌翻譯。

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database