ADOPICXISANSI

Instructs OpenESQL to pass string and character variables as ANSI.
Note: By default, the OpenESQL .NET Managed Run-time system maps PIC X host variables to ANSI strings when data is sent to the server. The default behavior in earlier versions of the run-time system 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 run-time and safe run-time only.