How to find invalid utf-8 character in oracle column?

Member

by orpha , in category: MySQL , 19 days ago

How to find invalid utf-8 character in oracle column?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lily , 18 days ago

@orpha 

To find invalid UTF-8 characters in an Oracle column, you can use the following query:

1
2
3
SELECT *
FROM your_table
WHERE REGEXP_LIKE(your_column, '[^[:ascii:]]');


This query uses the REGEXP_LIKE function to find any characters in the column that are not in the ASCII character set, which may indicate invalid UTF-8 characters. You can replace 'your_table' with the name of your actual table and 'your_column' with the name of the column you want to check.