Paul,

tricky question.

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

Fortunately in german we don't have to mess around with accents (´`^) so
I'm not sure about this one.

And it will be depending on the way the users are searching.

To give you an example.
In german we have the Umlaute (äöü), which should be treated as ae, oe,
ue. But they are ordered like 'a', 'o', 'u'.

So when you're searching for a record with (for example) 'STARTING WITH'
you'll get the 'ä' when you enter it.
But if you're searching by a lookup-combo and the field is collated
PXW_INTL850 you'll find it as well when entering 'ä' as well as 'a'.

Since I think the same will go for the 'é', 'è', 'ê' I think there's a
"all-pupose-solution".

Go ahead and try with a test-database (and if you do so, send the
results to Thomas St. (don't dare more letters at the moment, they might
be wrong again *g*) maybe he'll become the absolute collation-guru that
way).

Or Jason might decide to cancel 5 hours more of sleep (that's almost his
weekly budget) and offer a A-CLASS solution *ggg*

But don't be afraid: I think IBO5 will have a "UseTimeWarpForSleep"
property.

:-))

Luc.

>
> 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
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/