Hi Ann,

> > "Name" VARCHAR(50) NOT NULL,
> >
> > Its Unicode_FSS.
> >
> > Now somehow some of the columsn have 60 characters in them? I have intenral
> > logic that is tripping up now because its "double" checking stuff from the
> > db and noticed that 60>50.
> >
> > How can this be in the db?
>
> Through the magic of variable length characters. Firebird's Unicode-FSS
> (aka UTC-8) checks for a byte-length overflow, but ignores character
> length overflows. One argument is "If the string fits in the space, why
> throw it out?" In the case of our system tables (nominally Unicode-FSS)
> that's really important or every name would be limited to 10 characters.

I think we need to solve this, but reading your post it's not that easy?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18-2-2005