Martijn Tonies wrote:

>
> Raymond,
>
> > > > The author, David Schnepper, requested that I look into what's
> > > > required for him to update it to be compatible with 1.5, but no-one
> > > > has replied to my request for help yet.
> > >
> > > I've contacted Dave a long while ago and we both think there won't be
> any
> > > issues with v1.5 and ibCollations. You just need to rename the library
> to
> > > fbintl2.dll.
> > >
> > Dmitry,
> >
> > I've just tested this and when I run in IB Expert:
> >
> > create table T2
> > (
> > "Name" Char(30) character set iso8859_1 BETA_DE_DE_NOCASE
> > );
> >
> > I get the message:
> >
> > The operation is not defined for system tables.
> >
> > The following is accepted:
> >
> > create table T2
> > (
> > "Name" Char(30) character set iso8859_1 DE_DE
> > );
>
> Ehm, actually both of these should return a syntax error.
>
> Why not use the proper collate syntax?
>
> "Name" Char(30) character set iso8859_1 COLLATE DE_DE
>

Thanks for picking this up.

I did use 'collate', but typed my message here from memory as it's on
a different computer.
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)