On 19 Jul 2001, at 19:36, Lucas Franzen wrote:

>
> 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)

Yeah I am in Canada, unfortunately I don't read German very well, if
I tried really hard, and had lots of time, I could probably get
through a page or two, now where is the English/German/English
dictiuonary, hmm on lie resource, maybe I could run it through
babblefish or something like that.

Can you set a global collation order, or do you need it on a field by
field basis, I'll see if I can find Thomas.

Paul

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