From the course: Database Foundations: Data Structures

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Additional common types

Additional common types

From the course: Database Foundations: Data Structures

Start my 1-month free trial

Additional common types

“

- [Instructor] There are many additional types of data that can be stored in a relational database, and they can get quite specialized. Support for these types will vary among different RDBMS platforms, though. So not every platform will have built-in support for every type. One common type is called a Boolean. This is used to store values such as true/false or on/off. This kind of data is often represented in user interfaces as a checkbox or a radio button where the value is either selected or not selected. In PostgreSQL, you would use the Boolean data type for this. But in SQL Server, it's called a bit data type. When you want to store currency values, you'll add a money column to your tables. This type is interesting because it has different behaviors between SQL Server and PostgreSQL. On SQL Server, money values are stored as decimals and they're accurate to 1/10000 of the monetary unit that they represent. However…

Contents