Subject Wierd behaviour with FBEmbedded.
Author plinehan
Hi all,


I am trying to write an app against FB Embedded.

I run the server and then using IBOConsole
create a db thusly.

-----------------------------
SET SQL DIALECT 3;

CREATE DATABASE 'D:\Paul\Hungarian\Dictionary\HUNG4.GDB'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1250;

/* Table: WORD, Owner: SYSDBA */

CREATE TABLE "WORD"
(
"WORD_ID" INTEGER NOT NULL,
"ENG_WORD" VARCHAR(50) CHARACTER SET ASCII NOT NULL,
"HUN_WORD" VARCHAR(50) CHARACTER SET WIN1250 NOT NULL COLLATE PXW_HUN,
PRIMARY KEY ("WORD_ID")
);
------------------------------------


Then, I switch off the server and try to connect to the
db using 4 different component sets.

Zeos, IBX, MBO and JvUIB.

Now, in Zeos, there is no way to specify the character set.

However, when I specify the charset WIN1250 I get the
following error message for the other 3 components.

-------------
bad parameters on attach or create database
CHARACTER SET WIN1250 IS NOT DEFINED.

Connection Error, Error code 5
----------------


I have tried everything - copying firebird.msg and
the fbintl.ll into the app directory, and nothing
works. I can't seem to be able to connect using
the character set that I want.


Any ideas?


Paul...