CHAR_AS_NCHAR= LIBNAME Option

Specifies the default character type to use for table columns.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	NO
Data source:	Netezza
See:	DBTYPE= data set option

Syntax

CHAR_AS_NCHAR=YES | NO

Use this option when you cannot use the DBTYPE= data set option for table columns that contain multilingual character data.

The SAS data set, local_cust, contains multilingual data in this example.

libname net netezza server=netsrv database=test uid=net1 pwd=net1 CHAR_AS_NCHAR=YES;

data net.customers;
set sas.local_cust;
run;