Solved

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

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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SyBase SQL DataTime Format 6 295
Sybase - Backup and restore db into other server 1 572
SQL Syntax 10 70
sybase output only middle rows 4 25
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

831 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