[fpc-pascal] SqlDB vs Zeos: TDataset.FieldDefs[].Size

Graeme Geldenhuys graeme at geldenhuys.co.uk
Fri Apr 19 17:59:07 CEST 2013


Hi,

I have a Firebird database living on a FreeBSD server. I did not specify
a charset when the database was created.

I have a table with a string field defined as VarChar(10).

When I use SqlDB and retrieve the Size of that field via...

   FDataset.FieldDefs[AIndex].Size

SqlDB returns 10, which is correct.

But when that exact same code above is run via Zeos, it returns 40.

Anybody know why?

I'm using Zeos from the SubVersion repository:

   http://svn.code.sf.net/p/zeoslib/code-0/trunk
   Revision: 2209


The same result is returned using Zeos and a MySQL 5.5 database, where
the field was also created as VarChar(10).


Regards,
  - Graeme -

-- 
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/




More information about the fpc-pascal mailing list