Hi Paul,

not with WIN1252, ISO8859_1 and I fear not with any character set else. The
only way to accomplish this is to maintain the correct where clause in the
background while the user types in a, e, ...

Thomas

> -----Original Message-----
> From: Paul Schmidt [mailto:paul@...]
> Sent: Thursday, July 19, 2001 9:03 PM
> To: Thomas Steinmaurer; IBObjects@yahoogroups.com
> Subject: RE: [IBO] Creating Database on the Fly Part Deux
>
>
> Thomas:
>
> 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
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>