Share via


SYS(987) - Map Remote Data to ANSI

Maps remote Unicode data retrieved through SQL pass-through or remote views to ANSI.

SYS(987 [, lExpr])

Parameters

  • lExpr
    True (.T.) - Unicode data is always fetched as ANSI. The ODBC driver performs the conversion from Unicode to ANSI.

    False (.F.) (Default) - Unicode data is fetched as Unicode.

Return Value

Logical data type. SYS(987) returns the previous setting.

If you call SYS(987) without the lExpr parameter, it returns current setting.

Remarks

SYS(987) can be used to return remote Varchar data as ANSI for use with Memo fields.

The SYS(987) setting is a global setting across all data sessions. After a remote cursor is created, changing the SYS(987) setting does not affect subsequent data fetches for the cursor even if REQUERY( ) is executed.

See Also

Reference

REQUERY( ) Function