Subject Re: TIBDatabase CreateDatabase default character set
Author jojogeyer
Thanks for your help!
The problem is that there is no property TIBDatabase.CharSet.
I switched to SQLDialect 1 and now it works! Strange. Are there any
problems with SQLDialect 1?

Regards
Johannes Geyer, Germany

--- In firebird-support@yahoogroups.com, Rolf & Sibylle Nussbaumer
<rosi@i...> wrote:
> jojogeyer wrote:
> > Hi everybody,
> >
> > trying to create a database with TIBDatabase. Works fine except
for
> > the character set. I always get a dynamic SQL error -104 when I
> > specify a default character set.
> > My code is:
> > with IBDatabase1 do
> > begin
> > Params.Clear;
> > SQLDialect := 3;
> > DatabaseName := 'D:\julitec\julitecCONTACT\Daten\test.gdb';
> > Params.Add('USER "sysdba"');
> > Params.Add('PASSWORD "masterkey"');
> > Params.Add('PAGE_SIZE 4096');
> > Params.Add('DEFAULT CHARACTER SET ISO8859_1');
> > CreateDatabase;
> > end;
> >
>
> The database's character set must match the property
> TIBDatabase.CharSet. You should add
>
> CharSet := 'ISO8859_1';
>
> before creating the database.
>
> Hope this helps
>
> Rolf Nussbaumer