Subject | Re: [firebird-support] Database creation |
---|---|
Author | Helen Borrie |
Post date | 2004-05-07T12:22:41Z |
At 11:56 AM 7/05/2004 +0000, you wrote:
/heLen
>Following scenario:Strange. I've always needed to declare character set for variables...IB 4, 5.x
>
>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).
/heLen