DBCLIENT_MAX_BYTES= LIBNAME Option

Specifies the maximum number of bytes per single character in the database client encoding, which matches SAS encoding.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	always set to match the maximum bytes per single character of SAS session encoding
Data source:	Oracle
See:	ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS= LIBNAME option, , ADJUST_NCHAR_COLUMN_LENGTHS= LIBNAME option, DBSERVER_MAX_BYTES= LIBNAME option

Syntax

Details

Examples

Example 1: Use Default Values for All Options

Example 2: Specify Different Settings for Various Options

Syntax

DBCLIENT_MAX_BYTES=max-client-bytes

Details

Use this option as the multiplying factor to adjust column lengths for CHAR and NCHAR columns for client encoding. In most cases, you need not set this option because the default is sufficient.

Examples

Example 1: Use Default Values for All Options

This example uses default values for all options.

libname x1 &engine &connopt
proc contents data=x1.char_sem; run;
proc contents data=x1.nchar_sem; run;
proc contents data=x1.byte_sem; run;
proc contents data=x1.mixed_sem; run;

Example 2: Specify Different Settings for Various Options

Here is one example of this.

libname x5 &engine &connopt ADJUST_NCHAR_COLUMN_LENGTHS=NO
ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS=NO DBCLIENT_MAX_BYTES=3;
proc contents data=x5.char_sem; run;
proc contents data=x5.nchar_sem; run;
proc contents data=x5.byte_sem; run;
proc contents data=x5.mixed_sem; run;

This next example also uses different settings for the various options.

libname x6  &engine &connopt ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS=YES
ADJUST_NCHAR_COLUMN_LENGTHS=YES DBCLIENT_MAX_BYTES=3;
proc contents data=x6.char_sem; run;
proc contents data=x6.nchar_sem; run;
proc contents data=x6.byte_sem; run;
proc contents data=x6.mixed_sem; run;