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?
Who is Participating?
namasi_navaretnamConnect With a Mentor Commented:
See this link

This has got all the info you need.


Namasi Navaretnam
alitor99Author Commented:
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?
Please see chapter 19, 20;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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.