Solved

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

Posted on 2003-10-23
3
2,223 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
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
namasi_navaretnam earned 100 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now