ANSI to OEM

How or Where can I see if ANSI to OEM is turned off or turned on.Mike,
In what context?
From BOL:
******
Connection Object - Auto Translate Parameter
Indicates whether OEM/ANSI characters are converted. This property can be
set to True or False. The default value is True. If this property is set to
True, SQLOLEDB performs OEM/ANSI character conversion when multibyte
character strings are retrieved from, or sent to, SQL Server. If this
property is set to False, SQLOLEDB does not perform OEM/ANSI character
conversion on multibyte character string data.
******
and
******
bcp
Using character mode, bcp, by default, always converts characters from the
data file to ANSI characters before bulk copying them into an instance of
SQL Server, and converts characters from SQL Server to OEM characters before
copying them to the data file. Extended character data can be lost during
the OEM to ANSI or ANSI to OEM conversions. To prevent loss of extended
characters, use Unicode character format, or specify a code page for the
bulk copy operation using -C (or the CODEPAGE clause for the BULK INSERT
statement).
******
HTH
Jerry
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:FB56D48A-23C7-48D5-9FFE-55C2C5978EFD@.microsoft.com...
> How or Where can I see if ANSI to OEM is turned off or turned on.|||"Mike" wrote:

> How or Where can I see if ANSI to OEM is turned off or turned on.
I would like to know where, on SQL, can I see if this option is turned on or
turned off...if you know a sp who could help me...