python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - codepoint

How to find UTF-8 codes via LIKE '%\xC2\xA0%'?

I have a column that contains NO-BREAK SPACE (\xC2\xA0) instead of SPACE and I need to find that rows. Copy-pasting works: SELECT PRODUCT_NAME FROM TABLE t WHERE PRODUCT_NAME LIKE '% %' but using the...
test-img

Vega

unicode

utf-8

codepoint

exasol

Votes: 0

Answers: 2

Latest Answer

Try WHERE regexp_Like(PRODUCT_NAME, UNISTR('\00A0')) Depending on your database character set you may try CHR(106) instead of UNISTR('\00A0') xC2 xA0 is not the code point, it is the binary represen...
test-img

Wernfried Domscheit

Posts

Questions

Blogs

Jobs