Solved

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

Posted on 2003-10-23
3
2,228 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
An analysis of the phishing scam that has been affecting Google users, along with steps to take for protection, as well as what to do if you receive one of the emails.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

920 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

12 Experts available now in Live!

Get 1:1 Help Now