Connection string keywords - Conversion properties

Use these IBM® i Access ODBC driver connection string keywords to change Conversion properties of the ODBC connection.

The following table lists connection string keywords for Conversion properties that are recognized by the IBM i Access ODBC driver:

Table 1. IBM i Access ODBC connection string keywords for Conversion properties
Keyword Description Choices Default
ALLOWUNSCHAR or AllowUnsupportedChar Specifies whether or not to suppress error messages which occur when characters that can not be translated (because they are unsupported) are detected. 0 = Report error messages when characters can not be translated

1 = Suppress error messages when characters can not be translated

 0
CCSID Specifies a codepage to override the default client codepage setting with. Client codepage setting or 0 (use default client codepage setting) 0
GRAPHIC This property affects the handling of the graphic (DBCS) data types of GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, and DBCLOB that have a CCSID other than Unicode. This property affects two different behaviors:
  1. Whether the length of a graphic field is reported as a character count or as a byte count by the SQLDescribeCol API.
  2. Whether graphic fields are reported as a supported type in the SQLGetTypeInfo result set
0 = Report character count, report as not supported

1 = Report character count, report as supported

2 = Report byte count, report as not supported

3 = Report byte count, report as supported

 0
HEXPARSEROPT or Hex Parser Option Specifies how SQL hexadecimal constants will be interpreted in SQL statements. 0 = Treat hexadecimal constants as character data

1 = Treat hexadecimal constants as binary data

 0
TRANSLATE or ForceTranslation Specifies whether or not to convert binary data (CCSID 65535) to text. When this property is set to 1, binary fields are treated as character fields. 0 = Do not convert binary data to text

1 = Convert binary data to text

 0
UNICODESQL Specifies whether or not to send Unicode SQL statements to the server. 0 = Send EBCDIC SQL statements to the server

1 = Send UCS-2 Unicode SQL statements to the server in UCS-2

 0
XLATEDLL or TranslationDLL Specifies the full path name of the DLL to be used by the ODBC driver to translate the data that is passed between the ODBC driver and the server. The DLL is loaded when a connection is established. Full path name of the translation DLL none
XLATEOPT or TranslationOption Specifies a 32-bit integer translation option that is passed to the translation DLL. This parameter is optional. The meaning of this option depends on the translation DLL that is being used. Refer to the documentation provided with the translation DLL for more information. This option is not used unless the XLATEDLL property is set. 32-bit integer translation option 0
Parent topic: Connection string keywords