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

2013-04-22 Thread LacaK
Graeme Geldenhuys wrote / napĂ­sal(a): On 2013-04-20 10:11, Ludo Brands wrote: TFieldDef.Size is expressed in bytes. Zeos, IIRC, assumes a conversion from any charset to utf8 could be made. Since UTF8 is up to 4 bytes per char, a VarChar(10) can need up to 40 bytes to be represented in the

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

2013-04-21 Thread Graeme Geldenhuys
On 2013-04-20 10:11, Ludo Brands wrote: > > TFieldDef.Size is expressed in bytes. Zeos, IIRC, assumes a conversion > from any charset to utf8 could be made. Since UTF8 is up to 4 bytes per > char, a VarChar(10) can need up to 40 bytes to be represented in the I assumed it has something to do with

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

2013-04-20 Thread Ludo Brands
On 04/19/2013 05:59 PM, Graeme Geldenhuys wrote: > 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 v

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

2013-04-20 Thread Graeme Geldenhuys
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, whic