Shulou(Shulou.com)06/01 Report--

The solution of Oracle rare word garbled

"

"(this + evening) [su words] is garbled and cannot be displayed properly (becomes a question mark)

Unfamiliar words. "

"(this + night) (suo) does not display properly by default under the ZHS16GBK character set.

In the test, the rare word type is changed from varchar2 to nvarchar2, and the utl_raw.cast_to_nvarchar2 function can be used to display normally in the database.

Select * from T1

The database character set is as follows:

Select * from nls_database_parameters

The T1 table is structured as follows:

Field An is of type VARCHAR2

Http://tool.chinaz.com/tools/unicode.aspx

-generate the corresponding unicode code for rare words

Select utl_raw.cast_to_varchar2 ('3C54') from dual

Select utl_raw.cast_to_nvarchar2 ('3C54') from dual

-Test varchar2 type cannot store obscure words properly "

"

Truncate table t1

Alter table T1 modify (a nvarchar2)

Insert into T1 values ('?, 1)

Select * from T1

Update t1

Set a =

(select utl_raw.cast_to_nvarchar2 ('3C54') from dual)

Where b = 1

Select * from T1

-testing the nvarchar2 type can store obscure words normally. "

'

Truncate table t1

Alter table T1 modify (a nvarchar2)

Insert into T1 values ('?, 1)

Select * from T1

Update t1

Set a =

(select utl_raw.cast_to_nvarchar2 ('3C54') from dual)

Where b = 1

Select * from T1

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.