Subject | Wierd behaviour with FBEmbedded. |
---|---|
Author | plinehan |
Post date | 2005-07-31T17:36:34Z |
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...
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...