>It seems very inconsistent. Creating a number of identical views from the same base table some fields come over correctly some don't and it's not always the same field(s) that are wrong. I can find no way of reproducing the errors consistently.
is it possible, that you are having the same trouble, where mysql is sending only over the trim() length of the fields not the complete padded fields ?


>>are you using the odbc dsn in the control panel, or are you using a connection string ?
Personally I use a connection string.

>I'm using the odbc dsn from the control panel

>I'm "pending" at the moment waiting for the moderator to approve me!
>
>Barry
Strange, I just checked again, and there are no pending members. You might try again to join.
Bob