Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > White Paper-Technical > Using Text Data

Using Text Data

This is a Technical Whitepaper on character set conversion Using text data
 
RSS Feed
 
 
 

Using Text Data

Description

There is currently an ASE limitation such that it cannot handle text data which changes in length due to character set conversion. If, in the process of retrieving text data from the server, the size of the data changes, you will not be able to retrieve the data.

This error occurs if all of the following are true:
  • The character set of the client and the server are different.
  • In converting from the server to the client character set, the data size changes.
  • A SELECT is done on a text field in the server.

The following is an example of the error message that appears:

TEXT data not supported when data size is changing between the ‘utf8’and ‘sjis’ character sets due to character set conversion. The conversion ratio is 2:1. Please connect again with conversions off, or use client-side conversions.


For Unicode-enabled servers, this problem will definitely appear with the following languages or scripts: Arabic, Cyrillic, Japanese, Chinese, Greek, Hebrew, Korean, and Thai. It will also appear with Western European languages if the data contains accented Latin characters.

Note: This problem is not specific to Unicode. The same problem will show up if the client and the server are configured to use different character sets; and they are using a combination of Shift-JIS and EUC-JIS.

Affected Products

  • All versions of ASE

Workaround

  • Turn off character set conversion, and perform the conversion of the text data on the client side. You can either turn character set conversion off completely or only for SELECTs on text fields.
  • Use a client with the same character set as the server to access the data. With a Unicode-enabled server, that means using a client that is using Unicode as its character set.

Solution

Support for conversion of text data is planned for a future release of ASE.


 

Related Links

DOCUMENT ATTRIBUTES
Last Revised: Jul 08, 2000
Product: Adaptive Server Enterprise
Technical Topics: Globalization, Unicode Support
  
Business or Technical: Technical
Content Id: 1009184
Infotype: White Paper-Technical
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics