interesting, can you explain the reason why Å is allowed but Ä is not?
Your best option is to enumerate the allowed characters (i.e. [ABCDE...]). I would abstain from ranges (A-Z), because they depend on character order, which is different between alphabets. Here is an example:
I honestly do not know why the german characters are not allowed but the swedish ones are.
Just been told to validate that way.
I don't really want to have to list all the characters for the different alphabets
Someone on the pl/sql forum reccommended
REGEXP_LIKE ( str
, '^[[:alnum:] -]+$'
AND str = TRANSLATE ( str
I will try this approach first
In addition to Christian:
Perhaps it is quicker to exclude the characters that you don't allow, instead of including all the ones that you DO allow. Use the caret to exclude certain characters: