Re: [fpc-devel] TMySQLConnection.LoadField field length

2005-06-05 Thread Joost van der Sluis
Sorry for the late reply.. On Thu, 2005-05-19 at 19:03 +0200, Bram Kuijvenhoven wrote: > After understanding what a VARCHAR is (namely some sort of shortstring > with a fixed maximum length), I wanted first to know whether a newer > MySQL server reports proper field lengths for fields like 'FORMAT

Re: [fpc-devel] TMySQLConnection.LoadField field length

2005-05-19 Thread Bram Kuijvenhoven
Joost van der Sluis wrote: If you need more help, let me know. (Or else, send in the patch!) I've tried several things with the mysql connection, with the following results so far: After understanding what a VARCHAR is (namely some sort of shortstring with a fixed maximum length), I wanted first

Re: [fpc-devel] TMySQLConnection.LoadField field length

2005-05-18 Thread Joost van der Sluis
> The TMySQLConnection.LoadField method from sqldb/mysql does not fetch the > field lengths properly. It uses mysql_fetch_field_direct, but this only > returns data about an entire column in your result set. It does not give > valid field lengths for fields of variable length. Is should use >

[fpc-devel] TMySQLConnection.LoadField field length

2005-05-13 Thread Bram Kuijvenhoven
Hi, The TMySQLConnection.LoadField method from sqldb/mysql does not fetch the field lengths properly. It uses mysql_fetch_field_direct, but this only returns data about an entire column in your result set. It does not give valid field lengths for fields of variable length. Is should use mysql_fe