In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
How to judge whether a string contains Chinese characters in oracle
1. 1 BLOG document structure map
I. 2 preface part 1. 2.1 introduction
Technical enthusiasts, after reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) Olympiad:
The judgment of ① full-width characters, or the judgment of strings containing Chinese characters
If there are any mistakes or imperfections in this article, please correct them as much as you can, ITPUB or QQ. Your criticism is the biggest motivation of my writing.
I. 2.2 introduction to the experimental environment
11.2.0.3 RHEL6.5
I. 2.3 introduction to this article
See the netizen asked, how to inquire whether a field data in the table contains full-width characters? This problem involves several functions: to_single_byte, length and lengthb. When I was doing development, I studied how to determine whether a string contains Chinese or not. In fact, it is the same in nature. Let's take a look at the experimental part.
I. 3 Experimental part I. 3.1 lengthb and length functions combined with to_single_byte functions
-contains Chinese characters, strictly speaking, full-width characters
SELECT l.name
Length (l.name)
Lengthb (l.name)
FROM xb_link l
WHERE length (l.name)! = lengthb (l.name)
AND length (l.name)
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.
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.