SQL-Data-Types by Kanak InfoSystems
SQL Data types are little different from DBMS (Database Management System) like Microsoft Access, MS SQL Server, MySQL, PostgreSQL and so on.
Learn More Introduction to Database (SQL) in Khmer with videos: Chapter 1 | Chapter 2 | Chapter 3
Below are common Data Types in SQL.
◾ Numeric data types: These data types are used to store numbers (exact numeric data types and approximate numeric data types)
◾Exact numeric data types: These data types store numbers with exact precision.
They include TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, and NUMERIC.
◾ Approximate numeric data types: These data types store numbers with approximate precision. They include FLOAT and REAL.
◾ Character and string data types: These data types are used to store text. They can be divided into two categories: character data types and Unicode character data types.
◾ Character data types: These data types store text that is encoded using a single-byte character set. They include CHAR and VARCHAR.
◾ Unicode character data types: These data types store text that is encoded using a Unicode character set. They include NCHAR and NVARCHAR.
◾ Date and time data types: These data types are used to store date and time values. They include DATE, TIME, DATETIME, DATETIME2, and SMALLDATETIME.
◾ Binary data types: These data types are used to store binary data. They include BINARY and VARBINARY.
◾ Miscellaneous data types: These data types are used to store special types of data. They include BIT, BLOB, CLOB, XML, CURSOR, and TABLE.
More in PL/SQL Data Type
source by Technicalblog
Free Khmer Ebook Download (PDF): Database | Microsoft Access | Python Programming