On 19 Jul 2001, at 18:39, Lucas Franzen wrote:
> >
> > Finally got this to work, and BTW it should be:
> >
> > CREATE DATABASE 'servername:/path/file.gdb' USER 'username' PASSWORD
> > 'password';
> >
> > However I now have a problem, I need to create it using SQL DIALECT
> > 1, and that presents a problem, how do I tell it to use dialect 1?
> > Sending the "SET SQL DIALECT 1' command in the script, doesn't pass
> > this on to the server.
> >
> > The reason for this is I am using Firebird, and the client has to
> > use IB 5.6, and I don't want to have to create seperate versions of
> > the SQL.
>
> 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?

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.

Paul









Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com