NCharBind database parameter

Description

Specifies whether PowerBuilder binds input string parameters
to the Char or NChar datatype.

Controls

• ADO.NET (Oracle.DataAccess.Client
  only)

• O90 Oracle9i

• O10 Oracle 10g

• ORA Oracle 11g

• SNC SQL Native Client for Microsoft SQL Server

Syntax

Parameter	Description
value	Specifies whether PowerBuilder binds string input parameters to the Char or NChar datatype. Values are: 0 Binds string input parameters to the Char datatype. 1 Binds string input parameters to the NChar datatype.

Default

NCharBind=1 for SNC, NCharBind=0 for other
interfaces

Usage

For Oracle, the default NcharBind=0 setting is recommended
for binding Char, Varchar, Long and Clob data. NcharBind=1
is recommended for binding Nchar, Nvarchar2 and Nclob data.

For SNC, the default NcharBind=1 is recommended for
binding Nchar, Nvarchar, Ntext and Nvarchar(max) data. It encodes
the string data as Unicode. NcharBind=0 is recommended
for binding Char, Varchar, Text and Varchar(max) data. This setting
converts the data to the ANSI string determined by the current operating
system code page.

Examples

See Also

• BindSPInput

• DisableBind

• RPCRebind

• UnicharBind

---