Hi Luc,

I'm listening :-). But calling me Thomas Steinberger instead of Thomas
Steinmaurer is similar to calling you "einen Schwaben" :-)))))).

Thomas

> -----Original Message-----
> From: Lucas Franzen [mailto:luc@...]
> Sent: Thursday, July 19, 2001 7:37 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Creating Database on the Fly Part Deux
>
>
>
> Paul,
>
> > > CREATE DATABASE
> > > 'servername:/path/file.gdb'
> > > PAGE_SIZE 4096
> > > DIALECT1
> > > USER 'SYSDBA' PASSWORD 'masterkey'
> > > DEFAULT CHARACTER SET WIN1252;
> > >
> > I didn't see the DIALECT1 item documented, and yeah I should add the
> > PAGE_SIZE and CHARACTER SET, are the various sets documented
> > anywhere?
>
> I just did trial and error with setting the SQL dialect :-)
>
> For the other settings: There is a documentation somehow, but don't ask
> me where *g*
> It's just that I'm working with Interbase for some years now and I do
> have a template text about page size and charcter set in my db-directory
> *g*
>
> > Here is what I need, the client is English, but they have an office
> > in Quebec, which is French, so AÀÁÂaàáâ should all be considered the
> > same, in case one of the Quebec employees decides to use the accented
> > characters.
>
> This is why I used WIN1252. Since you wrote "Part Deux" I think I
> remembered you being in Canada I thought it would be a good idea to use
> a charc ter set which is able to:
> - translate the á à ê etc correctly to UpperCase
> - and which would allow you to use an appropriate collation order
> (PXW_INTL850). If you're able to read german (judging from your family
> name their might be a chance ;-)) you could ask Thomas Steinberger (very
> active in this list) for his charcaterset tests on ISO8859_1 with
> collate de_de, and WIN1252 as well with collation PXW_INTL as
> PXW_INTL850)
>
> HTH
> Luc.
>
>
> >
> > Paul
> >
> > Paul Schmidt,
> > Tricat Technologies
> > Email: paul@...
> > Website: www.tricattechnologies.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>