Peperl

Hi all

I am using AdoDB objects and MySQL. When I try to get the length of a field using the defined size property of the recordset object it works fine, but when the fields is a varchar, i only get the length of the largest field i have in the database

for example, i have a field that is a varchar(100), but the defined size returns me 5 if I the largest field that I have is "Hello"

Is this normal, and, there is a way to get the real defined size of the field?


Thanks

MKoslof

The DefinedSize is returning the length of the longest field value in the table, not the maximum length of the field's varchar definition.

A workaround would be to use 'SHOW COLUMNS FROM TableName' and then parse the length value out of the 'Type' field of each returned record.

Or, If you are updating a MySQL text field using ADO, you should set column size optimization OFF in your MyODBC options screen. Otherwise, the ADO DefinedSize property incorrectly reflects the optimized size instead of the defined size.

Peperl

Thanks for the idea MKoslof, works perfectly

MKoslof

No problem, glad to help