Perbedaan Tipe Data (Data Types) VB6 dan MySQL

Berikut ini perbandingan tipe data (Data Types) Visual Basic 6 dan database MySql Server

MySQL Datatype	Length	VB6 Datatype	Length
TINYINT	-128 to 127	integer	-32,768 to 32,767
TINYINT UNSIGNED	0 to 255	byte	0 to 255
SMALLINT	-32,768 to 32,767	integer	-32,768 to 32,767
SMALLINT UNSIGNED	0 to 65,535	long	-2,147,483,647 to 2,147,483,647
MEDIUMINT	-8,388,608 to 8,388,607	long	-2,147,483,647 to 2,147,483,647
MEDIUMINT UNSIGNED	0 to 16,777,215	long	-2,147,483,647 to 2,147,483,647
INT	-2,147,483,647 to 2,147,483,647	long	-2,147,483,647 to 2,147,483,647
INT UNSIGNED	0 to 4,294,967,295	double	64 Bit
BIGINT	64 Bit	N/A	N/A
FLOAT	32 Bit Floating Point	single	32 Bit Floating Point
DOUBLE	64 Bit Floating Point	double	64 Bit Floating Point
DECIMAL	Variable Floating Point	double	64 Bit Floating Point
CHAR	1 to 255 Characters	string	1 to Approx. 2,000,000,000 Characters
VARCHAR	1 to 255 Characters	string	1 to Approx. 2,000,000,000 Characters
TINYTEXT	1 to 255 Characters	string	1 to Approx. 2,000,000,000 Characters
TEXT	1 to 65535 Characters	string	1 to Approx. 2,000,000,000 Characters
MEDIUMTEXT	1 to 16,777,215 Characters	string	1 to Approx. 2,000,000,000 Characters
LONGTEXT	1 to 4,294,967,295 Characters	N/A	N/A
all BLOB types	1 to 4,294,967,295 Bytes	Variant	Varies
DATE	Date without Time	date	Date and Time value
DATETIME	Date and Time	date	Date and Time value
TIMESTAMP	Date and Time	date	Date and Time value
TIME	Time	date	Date and Time value
YEAR	Year	integer	-32,768 to 32,767
ENUM	Enumeration of Value Set	string	1 to Approx. 2,000,000,000 Characters
SET	Set of Values	string	1 to Approx. 2,000,000,000 Characters

Tags:

daftar data type data vb, daftar data type mysql, perbedaan tipe data vb dan mysql, bagan tipe data vb6, vb6 dan mysql, mysql download, apa saja tipe data vb, penjelasan type data vb dan mysql, penjelasan type data mysql server, data type definition, data type adalah, vb tutorial, tutorial vb mysql