Selecting a character-set converter  Improving character-set conversion performance

Chapter 2: Programming Information

Setting the CHARSET connection property

You can specify the character set to use in your application by setting the CHARSET driver property. If you do not set the CHARSET property:

You can also use the -J charset command line option for the IsqlApp application to specify a character set.

To determine which character sets are installed on your Adaptive Server, issue the following SQL query on your server:

select name from syscharsets
 go

For the PureConverter class, if the designated CHARSET does not work with the client’s Java Virtual Machine (VM), the connection fails with a SQLException, indicating that you must set CHARSET to a character set that is supported by both Adaptive Server and the client.

When the TruncationConverter class is used, character truncation is applied regardless of whether the designated CHARSET is 7-bit ASCII or not.





Copyright © 2003. Sybase Inc. All rights reserved. Improving character-set conversion performance

View this book as PDF