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

How to judge whether a string contains Chinese characters in oracle

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.

Share To

Database

Wechat

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

12
Report