NCharBind

Description

Specifies whether InfoMaker binds string variables in a program to an internal variable with the Oracle Char or Oracle NChar datatype.

Applies to

ADO.NET (Oracle.DataAccess.Client only)
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g

Syntax

NCharBind=value

Parameter	Description
value	Specifies whether InfoMaker binds string variables in a program to an internal variable with the Char or NChar datatype. Values are: 0 (Default) InfoMaker binds string data as a Char datatype. 1 InfoMaker binds string data as an NChar datatype.

Parameter

Description

value

Specifies whether InfoMaker binds string variables in a program to an internal variable with the Char or NChar datatype. Values are:

0 (Default) InfoMaker binds string data as a Char datatype.
1 InfoMaker binds string data as an NChar datatype.

Default

NCharBind=0

Usage

With NCharBind=1, the Oracle drivers bind all string parameters to internal variables with the NChar datatype. If the string parameters are a mix of Char and NChar or NVarChar2 datatypes, set NcharBind=1 to ensure that the NChar data is bound correctly. If all string parameters have a Char datatype, set NcharBind=0 (the default), because binding a Char variable as an NChar datatype substantially downgrades the Oracle database driver's performance.

You must also make sure that NCharBind is set correctly when you update data with the Oracle LONG, CLOB, or NCLOB datatype using a DataWindow object. If the datatype is LONG or CLOB, set NCharBind to 0. If the datatype is NCLOB, set NCharBind to 1. If NCharBind is not set correctly, incorrect data will be updated to the database. The setting of NCharBind does not affect UPDATEBLOB statements.

Examples

Example 1

To specify that string arguments should be bound as the NChar datatype, select the NChar Bind box on the Transaction page in the Database Profile Setup dialog box.