Getting error "character set xxxx not defined" when connecting to a database

By: Borland Staff

Abstract: Resolved in InterBase 5.5.

Problem:
When trying to connect to database after setting the character set, 
WISQL or ISQL returns error "character set xxx not defined".  


Solution:
Check if the following scenerio matches your problem:


* You have a database with a character set.  Something like this:

sql>create database "c:tempinternational.gdb" default character set 
win1252;


* In another  isql session, attempt to connect to the database.

sql>set names win1252;
sql>connect "c:tempinternational.gdb";

* It will error out with this:

"bad parameters on attach or create database
-CHARACTER SET WIN1252 is not defined"

*  And you are using InterBase version WI-V5.1.1.680.

If your problem matches the above case, this is due to a bug on IB version WI-V5.1.1.680.
This problem is fixed in version WI-V5.5.737.

Server Response from: ETNASC04