Perbedaan Tipe Data (Data Types) VB6 dan MySQL | DASAR PROGRAMER

Perbedaan Tipe Data (Data Types) VB6 dan MySQL

Berikut ini perbandingan tipe data (Data Types) Visual Basic 6 dan database MySql Server
MySQL DatatypeLengthVB6 DatatypeLength
TINYINT-128 to 127integer-32,768 to 32,767
TINYINT UNSIGNED0 to 255byte0 to 255
SMALLINT-32,768 to 32,767integer-32,768 to 32,767
SMALLINT UNSIGNED0 to 65,535long-2,147,483,647 to 2,147,483,647
MEDIUMINT-8,388,608 to 8,388,607long-2,147,483,647 to 2,147,483,647
MEDIUMINT UNSIGNED0 to 16,777,215long-2,147,483,647 to 2,147,483,647
INT-2,147,483,647 to 2,147,483,647long-2,147,483,647 to 2,147,483,647
INT UNSIGNED0 to 4,294,967,295double64 Bit
BIGINT64 BitN/AN/A
FLOAT32 Bit Floating Pointsingle32 Bit Floating Point
DOUBLE64 Bit Floating Pointdouble64 Bit Floating Point
DECIMALVariable Floating Pointdouble64 Bit Floating Point
CHAR1 to 255 Charactersstring1 to Approx. 2,000,000,000 Characters
VARCHAR1 to 255 Charactersstring1 to Approx. 2,000,000,000 Characters
TINYTEXT1 to 255 Charactersstring1 to Approx. 2,000,000,000 Characters
TEXT1 to 65535 Charactersstring1 to Approx. 2,000,000,000 Characters
MEDIUMTEXT1 to 16,777,215 Charactersstring1 to Approx. 2,000,000,000 Characters
LONGTEXT1 to 4,294,967,295 CharactersN/AN/A
all BLOB types1 to 4,294,967,295 BytesVariantVaries
DATEDate without TimedateDate and Time value
DATETIMEDate and TimedateDate and Time value
TIMESTAMPDate and TimedateDate and Time value
TIMETimedateDate and Time value
YEARYearinteger-32,768 to 32,767
ENUMEnumeration of Value Setstring1 to Approx. 2,000,000,000 Characters
SETSet of Valuesstring1 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
Jika Anda menyukai Artikel di blog ini, Silahkan klik disini untuk berlangganan gratis via email, dengan begitu Anda akan mendapat kiriman artikel setiap ada artikel yang terbit di dasarprogrammer.blogspot.com

0 komentar:

Posting Komentar