Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Garbled codes when Chinese characters are very commonly used in ORACLE database

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

As the system needs to support Chinese input from the mainland and Taiwan, there are often unusual characters that are not included in GBK coding. If the character set is not set properly, it will be reflected as Chinese garbled.

Such as Zuo

Create table ttt (name varchar2 (10)); insert into ttt (name) values ('weather'); insert into ttt (name) values ('weather'); insert into ttt (name) values ('loser'); select * from ttt

Display before adjustment?

Adjust the database code to SIMPLIFIED CHINESE_CHINA.AL32UTF8

Set NLS_LANG to SIMPLIFIED CHINESE_CHINA.AL32UTF8

After adjustment, the retest shows normal

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report