Wrong ColumnSize returned by GetSchemaTable

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Andrea Rocca
Posts: 5
Joined: Fri 10 Mar 2006 15:50

Wrong ColumnSize returned by GetSchemaTable

Post by Andrea Rocca » Wed 21 Feb 2007 10:49

In version 3.55.20.0 the property ColumnSize return wrong ColumnSize using GetSchemaTable of DataReader object.

For example a VARCHAR(255) field return a size of 765 (2FD) !!!!
Top
Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 21 Feb 2007 11:37

I reckon you use UTF8 (which is 3 bytes encoding), don't you?
That's why method returns 765 instead of 255 (765=255*3).
Top
Andrea Rocca
Posts: 5
Joined: Fri 10 Mar 2006 15:50

Thanks

Post by Andrea Rocca » Wed 21 Feb 2007 17:29

You are in right.

Thanks
Top
Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 23 Feb 2007 07:21

Not at all.
Top
Post Reply

Return to “dotConnect for MySQL”