Summary
Visual Basic can be very loose with it's data types. If you want to avoid worrying about which type of data is coming from your database, you can simply not specify a datatype when you declare a variable, which defaults the datatype to variant. The variant should be avoided whenever possible, as it can be very CPU and memory intensive. This article demonstrates the different MySQL and VB6 datatypes and how they correlate.
This article was written by Mike Hillyer and published on January 22, 2004 on MySQL.com. This link has been provided to help you quickly and easily to find the answers to your questions.