VBScript Data Types

At its simplest, a Variant can contain either numeric or string information. A Variant behaves as a number when you use it in a numeric context and as a string when you use it in a string context. That is, if you're working with data that looks like numbers, VBScript assumes that it is numbers and does the thing that is most appropriate for numbers. Similarly, if you're working with data that can only be string data, VBScript treats it as string data. Of course, you can always make numbers behave as strings by enclosing them in quotation marks (" ").

Variant Subtypes

Beyond the simple numeric or string classifications, a Variant can make further distinctions about the specific nature of numeric information. For example, you can have numeric information that represents a date or a time. When used with other date or time data, the result is always expressed as a date or a time. Of course, you can also have a rich variety of numeric information ranging in size from Boolean values to huge floating point numbers. These different categories of information that can be contained in a Variant are called subtypes. Most of the time, you can just put the kind of data you want in a Variant, and the Variant behaves in a way that is most appropriate for the data it contains. The following table shows the subtypes of data that a Variant can contain.

Empty - Variant is uninitialized. Value is 0 for numeric variables or a zero length string ("") for string variables.

Null - Variant intentionally contains no valid data.

Boolean - Contains either True or False.

Byte - Contains integer in the range 0 to 255.

Integer - Contains integer in the range 32,768 to 32,767.

Currency Long -(-922,337,203,685,477.5808 to 922,337,203,685,477.5807). Contains integer in the range -2,147,483,648 to 2,147,483,647.

Single range - Contains a single precision, floating point number in the 3.402823E38 to 1.401298E 45 for negative values; 1.401298E 45 to 3.402823E38 for positive values.

Double -Contains a double precision, floating point number in the ,range 1.79769313486232E308 to 4.94065645841247E324 for negative values; 4.94065646841247E 324 to 1.7976931 3486232E308 for positive values.

Date (Time) - Contains a number that represents a date between January 1, 100 to December 31, 9999.

String - Contains a variable length string that can be up to approximately 2 billion characters in length.

Object Error - Contains an object. Contains an error number.

You can use conversion functions to convert data from one subtype to another. In addition, the VarType function returns information about how your data is stored within a Variant.

Domain Name Search