Data Types in SQL - List of Data Types in SQL, Data Types in Oracle, Data Types in MySql, MS Access Data Types


Data Types in SQL - List of Data Types in SQL, Data Types in Oracle, Data Types in MySql, MS Access Data Types
Data Types are used to store the kind of data into a table columns. Every columns in database has its own data type.

The SQL Data Types change according to the Database. I am Showing The list of common Data Types according to the Databases.

MS Access Data Types:-

Text - Text is used to store the combination of Characters maximum range is 255 characters only.
Memo - Memo is used to store the combination of characters maximum range is 65,536 characters.
Byte - Used to store the numbers range is 0 to 255.
Integer - Used to store the numbers range is -32768 to 32767.
Long - Used to store the numbers range is -2,147,483,648 to 2,147,483,647.
Double - Used to store real numbers.
Currency - Used to store the currency according to the country. you can store 15 digit's currency with 4 decimal points.
AutoNumber - Used to give the number automatically to the field usually start from 1 but you can change the starting point. 

Oracle Data Types:-


Char() - Char is used to store the combination of Characters maximum range is 2000 characters only and once the lenght is given to the column with char it is fixed.
Varchar - Varchar is used to store the combination of Characters as well the only difference b/w char and varchar is the varchar size depends upon the characters inputted. 
Currency - Used to store the currency according to the country. you can store 15 digit's currency with 4 decimal points.
AutoNumber - Used to give the number automatically to the field usually start from 1 but you can change the starting point. 









{ 0 comments... read them below or add one }

Post a Comment