搜索不是英文文本的数据 [英] Search for data that is not english text

问题描述

简而言之:我需要能够在Oracle DB内的某一列内搜索所有非英语文本或包含-^等符号的事件. (大写和非大写都可以) 总的来说，我希望找到所有出现的其他语言，例如韩语西班牙语等.

ID    NAME      DATE
1     TEST      2018-12-02 11:09:05
2     TE-ST     2018-12-02 11:09:05
3     测试       2018-12-02 11:09:05

我希望查询仅找到第3行.

解决方案

with test as
(
select 'hello good morning' txt from dual 
union select 'Bad weather' from dual
union select '测试 ' from dual
    union select 'L''Inhêrit ' from dual
    union select 'هلا' from dual
)
select *
from test
where txt != asciistr( txt )

in a nutshell: I need to be able to search within Oracle DB inside a certain column, for all occurrences that are not English text, or contain signs like -^ etc'. (capital and non-capital are ok) in general, I'm looking to find all occurrences of other languages, Korean Spanish etc'.

ID    NAME      DATE
1     TEST      2018-12-02 11:09:05
2     TE-ST     2018-12-02 11:09:05
3     测试       2018-12-02 11:09:05

i expect the query to find only row #3.

解决方案

with test as
(
select 'hello good morning' txt from dual 
union select 'Bad weather' from dual
union select '测试 ' from dual
    union select 'L''Inhêrit ' from dual
    union select 'هلا' from dual
)
select *
from test
where txt != asciistr( txt )

这篇关于搜索不是英文文本的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！