Subject Re: [firebird-support] Database creation
Author Helen Borrie
At 11:56 AM 7/05/2004 +0000, you wrote:
>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) character set ISO8859_1) <---
>as
>begin
> name = 'aßa';
> suspend;
>end
>^
>commit work^
>
>set term ;^
>
>
>I want to mention that I didn't have this problem with InterBase
>(same scenario).

Strange. I've always needed to declare character set for variables...IB 4, 5.x

/heLen