Kato
Joined: 05 Mar 2010
Posts: 47
|
 Posted: Fri Nov 18, 2011 1:24 Post subject: ODBC and data types |
 |
|
Hi all,
Since ODBC only accepts string data type, does it mean that the tables should only store strings, to avoid conversion/casting? My current tables have mostly integer fields and use the InnoDB engine(MySQL). I'm using integers to speed-up operations with indexes, yet I'm not sure about the real benefits.
For instance, some of my queries do not wrap passed data with ' ', since the passed data is integer. It works, but I guess that the data must be converted by ODBC before reaching MySQL itself? Would it be faster to use string data in my tables and put the passed data between ' ' ?
Thank you!
Kato |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
