> > I have some tables with fields of varchar type, when I set field length
> > to (for exaple) 30 char, firebird can store 90 char, where am I wrong?
> >
> > FIREBIRD 2.0
> > PAGE_SIZE 8192
> > DEFAULT CHARACTER SET UNICODE_FSS
> >
> >
>
> UNICODE_FSS has variable length characters. Falcon estimates the
> character length as three bytes. Most common characters in English
> and unaccented characters in Latin1 are stored in a single byte
> in UNICODE_FSS, so Falcon stores three times as many characters
> as the field declaration allows. That's probably wrong, but it's
> the way it works.

So, Falcon is wrong to begin with? I see MySQL hasn't improved then...

;-)

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com