Troubleshooting and Error Messages Guide

Home

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Character Set Conversion Errors

Error 2409

Severity

Error message text

Cannot find the requested character set in Syscharsets: name = '%.*s'.

Explanation

Information about the character sets that are defined for use by Adaptive Server is stored in syscharsets. Error 2409 occurs when Adaptive Server cannot find a character set needed for character set conversion.

Error 2409 can occur in the following situations:

When a client requests a connection, Adaptive Server checks whether it can convert from the client's character set to its own character set. If Adaptive Server cannot do the requested conversion because a character set is not found, Error 2409 is raised.
If you use the set char_convert command to start conversion between the Adaptive Server character set and a different character set and the character set you specify does not exist in syscharsets, Error 2409 is raised.

Action

Make sure all necessary character sets are loaded, including the client's character set (as shown in the error message output):

1> use master
2> go

1> select csid, id, name from syscharsets
2> go

 csid id  name                           
 ---- --- ------------------------------ 
    0   0 ascii_8                        
    0   1 iso_1    
    1  50 bin_iso_1

If you are missing needed character sets, follow the directions in the Adaptive Server installation and configuration guide to load them using the sybinit utility.

Standalone Utilities

By default, for standalone utilities, the character set used for the client is the default for the platform. This may not be the correct character set. If the 2409 error is occurring while you are using isql, bcp, or defncopy, use the -J (UNIX and NT) or /clientcharset (OpenVMS) command-line option to specify the client character set.

Open Client Applications

For Open Client applications such as DB-Library, you can specify the character set for the client through the login packet. Refer to the reference manual for the application and the Open Client/Server Supplement for your platform for details.

Additional information

Refer to "Configuring Client/Server Character Set Conversions" in the System Administration Guide for details about character set conversion.

Versions in which this error is raised

All versions


	Expand Search