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/