FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Lowden, James K writes:
 > All, 
 > 
 > For anyone who cares and hasn't seen it, there's a fairly succinct
 > description of Sybase's character set handling in their International
 > Developer's Guide at
 > http://manuals.sybase.com/onlinebooks/group-cn/cng1250e/i_and_l/@Generic__Bo
 > okView       
 > 
 > Specifically, 
 > http://manuals.sybase.com/onlinebooks/group-cn/cng1250e/i_and_l/@Generic__Bo
 > okTextView/3170;pt=3129
 > 
 > In a nutshell, from what I can see, the server converts between several
 > character sets.  The client's default character set is determined from the
 > locale environment variables, and ct_bind can be used to coerce other
 > conversions.  
 > 
 > I found no localization or character set support in the db-lib docs.  

You can set the client charset via DBSETLCHARSET() in DBlib.

For CTlib charset handling is generally handled via the cs_locale()
interface.

The server can do conversions where the size of characters is the
same, or where the target is narrower than the source. It can't (in
general) do conversions where the target is wider than the source.

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com