ADOPICXISANSI

Instructs OpenESQL to pass string and character variables as ANSI.

Note: By default, the OpenESQL .NET Managed Runtime maps PIC X host variables to ANSI strings when data is sent to the server. The default behavior in earlier versions of the runtime mapped the variable to Unicode strings, occasionally causing performance problems on some servers. The current default corrects these problems in most cases; however, in rare cases where this change causes decreased performance, specify NOADOPICXISANSI to restore the original behavior.

Syntax:

ADOPICXISANSI
NOADOPICXISANSI

Properties:

Default:

ADOPICXISANSI

Scope:

Used at compile time:	No
Behavior at run time:	Process

See Scope - OpenESQL SQL Compiler Directive Options for more information.

Comment:

ADOPICXISANSI applies to managed ADO.NET runtime and safe runtime only.