Walker
Walker

Reputation: 1307

Detect chinese (multibyte) character in a string in a column in oracle database

how can i detect that a column in oracle database has chinese (multibyte) characters in it.

Upvotes: 1

Views: 5898

Answers (1)

Roy Tang
Roy Tang

Reputation: 5771

Try "where length(column) < lengthb(column)"

Upvotes: 9

Related Questions