In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-21 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
This article is from the official oracle blog. The character set of many customers' database is ZHS16GBK, but some special obscure words are not included in this character set. Here is an example of how to insert these two characters into the database.
1. Description:
The nls_characterset of the database is ZHS16GBK, and NLS_NCHAR_CHARACTERSET is AL16UTF16.
The tool used to insert data is sqldeveloper, and the corresponding version is 4.2.0.17.089
two。 Query the Unicode code of these two words
There are many Unicode-related websites on the Internet, and the Unicode codes corresponding to these two words can be found through the relevant websites:
Encoding Unicode: 4DAE
Encoding Unicode: 3F06
3. Create a test table
Create table test (name nvarchar2 (30))
4. Insert data
SQL > insert into test values (N'roomgirls')
Must be prefixed with the letter "N", otherwise the inserted data is still garbled!
SQL > commit
5. Validate data
SQL > select name,dump (name,1016) b from test
NAME B
Beautiful Typ=1 Len=4 CharacterSet=AL16UTF16: 4dpenny aepene 3fjingle 6
The word "notify" has been successfully inserted into the table and can be displayed correctly. The corresponding Unicode code is 4d _ 6, which is consistent with the result of the query in the first step.
Related references:
The National Character Set (NLS_NCHAR_CHARACTERSET) in Oracle 9i, 10g, 11g and 12c (Doc ID 276914.1)
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: 262
*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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.