Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to use UTF-8 to solve the problem of rare words in GBK". In daily operation, I believe many people have doubts about how to use UTF-8 to solve the problem of rare words in GBK. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "how to use UTF-8 to solve the problem of rare words and garbled codes in GBK". Next, please follow the editor to study!

Many rare words in the GBK character set cannot be displayed, or can be displayed, but after filtering using regular expressions, it is found that rare words have been filtered out. The system believes that rare characters are not Chinese characters.

Create a GBK database first

Execute SQL after opening the database

CREATE TABLE "SYSDBA". "T1"

(

"A" VARCHAR2 (50))

Insert into t1

Values ('in  Bin')

SELECT FROM regressive expandable replace (Ameme'[: punct:]') FROM T1

Insert data into the table and filter using rules

After discovering and screening. The Chinese characters in the middle are gone. Now create a database for UTF-8.

Migrate this piece of data to a new UTF-8 library using DTS

Execute the regular expression SQL again

UTF-8 does slightly reduce the problem of filtering obscure words or displaying errors.

But these are only part of the remedy. The best way is to communicate the requirements at the beginning, and use the UTF-8 character set directly if there are rare words.

At this point, the study on "how to use UTF-8 to solve the problem of rare words and garbled characters in GBK" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.