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

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.

Examples

Example 1

To specify that string arguments should be bound as the NChar datatype:

Database profile Select the NChar Bind box on the Transaction tab in the Database Profile Setup dialog box.