Subject | Database creation |
---|---|
Author | lackonagy |
Post date | 2004-05-07T11:56:39Z |
Following scenario:
Win2k, FireBird 1.5 (.0.3815), delphi 5, IB_Objects 3.6
1 Form, 1 IB_Connection, 1 IB_Transaction, 1 IB_Script.
IB_Script - IB_Connection - IB_transactions are linked (properties
set).
Here's the script contained by the IB_Script:
SET SQL DIALECT 3;
SET NAMES ISO8859_1;
CREATE DATABASE 'C:\MyDB.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1;
commit work;
set term ^;
create procedure someproc
returns (name varchar(32))
as
begin
name = 'aßa';
suspend;
end
^
commit work^
set term ;^
=============================
IB_Script.Execute;
=============================
After this when trying to execute the procedure "someproc" I get
the "cannot transliterate character between character sets" error.
Although, if disconnect/connect occures between the "Create
Database..." and "Create Procedure..." statements the
procedure "someproc" executes fine.
I want to mention that I didn't have this problem with InterBase
(same scenario).
Any ideas, suggestions? Am I doing something wrong?
Thanx,
Lacko.
Win2k, FireBird 1.5 (.0.3815), delphi 5, IB_Objects 3.6
1 Form, 1 IB_Connection, 1 IB_Transaction, 1 IB_Script.
IB_Script - IB_Connection - IB_transactions are linked (properties
set).
Here's the script contained by the IB_Script:
SET SQL DIALECT 3;
SET NAMES ISO8859_1;
CREATE DATABASE 'C:\MyDB.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1;
commit work;
set term ^;
create procedure someproc
returns (name varchar(32))
as
begin
name = 'aßa';
suspend;
end
^
commit work^
set term ;^
=============================
IB_Script.Execute;
=============================
After this when trying to execute the procedure "someproc" I get
the "cannot transliterate character between character sets" error.
Although, if disconnect/connect occures between the "Create
Database..." and "Create Procedure..." statements the
procedure "someproc" executes fine.
I want to mention that I didn't have this problem with InterBase
(same scenario).
Any ideas, suggestions? Am I doing something wrong?
Thanx,
Lacko.