Re: validation of unicode / ascii

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 23 Jan 2002 18:38:30 +0100
Message-ID: <j5tt4uc2qkb0n5133mjhfi6hnkeb94ohpm@4ax.com>

On Wed, 23 Jan 2002 16:19:44 +0800, "Master" <xxx_at_xxx.com> wrote:

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

select * from nls_database_parameters will give you the characterset and the national characterset of the database. Obviously, all varchar2 columns are in the characterset and all nvarchar2 columns in the national characterset and there is no way nor need to verify individual columns.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 23 2002 - 11:38:30 CST