Re: validation unicode or ascii?

From: Svend Jensen <Master_at_OracleCare.Com>
Date: Wed, 23 Jan 2002 20:54:28 +0100
Message-ID: <3C4F14F4.9000002@OracleCare.Com>

Master wrote:

> is there any package or way to check the input field is unicode or ASCII in
> PL/SQL?
>
>
>
>

Prop. not, and you not need to, the session process converts from client charset to database charset, if possible. Check view v_$nls_valid_values on the server. Listed charsets are OK client charsets.

It is a problem having a us7ascii database and utf8/unicode or we8iso8859p1 client, codes with values above 127 do not fit into us7ascii and are converted to ?.

/Svend Jensen Received on Wed Jan 23 2002 - 13:54:28 CST