?
Solved

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

Posted on 2003-10-23
3
Medium Priority
?
2,243 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:alitor99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
namasi_navaretnam earned 200 total points
ID: 9607667
See this link

http://sybooks.sybase.com/onlinebooks/group-asarc/asg1192e/svrtsg/@Generic__BookTextView/30531

This has got all the info you need.


HTH

Namasi Navaretnam
0
 
LVL 1

Author Comment

by:alitor99
ID: 9613414
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?
0
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 9615973
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
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The top devops trends for 2017 are focused on improved deployment frequency, decreased lead time for change and decreased MTTR.
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question