On 19 Jul 2001, at 20:01, Thomas Steinmaurer wrote:

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

Character sets, collation orders, this could get tricky, anyway Lucas
says you have done alot with this stuff, so maybe you can give me a
hand:

Now, here is what I need, say they have a doofus at the Montreal
office who is bound and determined to type Montrèal or is it Montréal
I can never remember which one is correct. I want them all
considered the same. It would be really nice if the database
considered them equal as in:

SELECT * FROM CUSTOMER WHERE CITY = 'Montreal', will also find
'Montrèal' or 'Montréal', but I can work around it, by capturing the
keyboard input and stuffing the proper character in, but I would
rather not do that.

Paul




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


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