asked on

Error converting client characters into server's character set, caused by extended ASCII characters

When trying to insert data into a Sybase ASE 12.5 database table, if it includes extended ASCII characters, I get the following error message

Server Message: Number 2402, Severity 16
Error converting client characters into server's character set. Some character(s) could not be converted.

Is this because I have the settings on my database (or server) set incorrectly? In which case what should I change? and how do I change it?

Or, do I need to some function(s) to convert the extended ASCII characters? In which case, have the necessary functions already been writeen? and where can I find them?

ASKER CERTIFIED SOLUTION

namasi_navaretnam

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

alitor99

ASKER

Thanks for the pointer. Utilising the help given there I have been able to lose the error message and save the data. However the 'offending characters' are saved as garbage, that is they are unrecognisable. Is there a solution that saves the characters correctly?

namasi_navaretnam

Please see chapter 19, 20

http://manuals.sybase.com/onlinebooks/group-as/asg1200e/asesag/@ebt-link;pt=50873?target=%25N%15_51096_START_RESTART_N%25

You may want to configure so that client and server use the same char set. Also see option
sp_configure "enable unicode conversions", 1

HTH