Home

	Expand Search

Access Service User's Guide DirectConnect

Chapter 2 Configuring the DirectConnect Access Service Library

Access Service (ACS) Required properties

DefaultTargetCodeset

DefaultTargetCodeset

Specifies the target code set the access service uses to convert characters when it sends data to the target database.

Syntax

DefaultTargetCodeset=targetcodeset

Range

1-255 characters

Default

No default

Values

The DefaultTargetCodeset value name corresponds to a code set identifier.

See Table 16-2 in Appendix B, "Quick Reference" for a table that lists all application code set names and code set identifiers.

Comments

• When data passes from the target database to the client application, the access service converts the data from the DefaultTargetCodeset to the DefaultClientCodeset. (See "DefaultClientCodeset" .)

• The DefaultTargetCodeset property enables the access service to support single-byte or mixed-byte language machines.

• To ensure that the access service returns data inserted into a table in the proper code set, use the same code set for both the insert and select operations. For example, if you insert an exclamation point character ("!", ASCII 0x21) where the ASCII-to-EBCDIC conversion is based on IBM EBCDIC (code set identifier 37), this byte is converted to 0x5A for storage on the target database. If you later select this data using the Western Europe code page (code set identifier 500), the 0x5A is converted to a right square bracket ("]", ASCII 0x5D). Therefore, always select data in the same code set in which it was inserted.

Examples

For single-byte language machines:

• If the machine is configured with French as the primary language, use the French code set of 297 as the targetcodeset:

  DefaultTargetCodeset=297

• If the machine is configured with U.S. English as the primary language, use the U.S. English code set of 37 as the targetcodeset:

  DefaultTargetCodeset=37

For mixed-byte language machines:

• If the machine is configured with Katakana as the primary language, use the following three code sets separated by commas as the targetcodeset:

  DefaultTargetCodeset=5026, 290, 4396

  where:

  • 5026 is the mixed-byte Katakana code set.

  • 290 is the associated single-byte code set.

  • 4396 is the associated double-byte code set.

• For English/Japanese machines, use the following code sets for the targetcodeset:

  DefaultTargetCodeset=5035, 1027, 4396

  where:

  • 5035 is the mixed-byte Japanese-English code set.

  • 1027 is the associated single-byte code set.

  • 4396 is the associated double-byte code set.