PLSQL IsAlpha() IsSpace() - Internationalization

From: Greg Harabedian <gharabed_at_pacbell.net>
Date: Thu, 15 Feb 2001 21:20:31 GMT
Message-ID: <3A8C4898.D6774387@pacbell.net>

Is there a way in PLSQL to determine if a character (possibly a multibyte character / UTF8 character set), is an alpha numeric value or is a space. I know there are typically functions in C/C++ even in OCI that will do this. For example in OCI the calls are:

OCIWideCharIsAlnum()
OCIWideCharIsSpace()

Is there a way to do this in PLSQL directly without having to manage character tables manually for every possible language/character set?

Your help is greatly appreciate.

Thanks,
greg
greg_at_lizardtech.com Received on Thu Feb 15 2001 - 15:20:31 CST