Tag: data types

User-Defined Data Types In SQL Server

SQL Server

SQL Server platform comes with many data types, but there are cases when they are not sufficient....
Read More

ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips

Database administation, Work with data

MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You set these permitted values during the...
Read More

VARCHAR and NVARCHAR Data Types in SQL Server

Database administation, Work with data

Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid...
Read More

SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases

Database administation, Work with data

This post has “strings attached: for a good reason. We are going to explore deep into SQL...
Read More

SQL FLOAT: 3 Points that Will Help you to Avoid Weird Math Errors

Database administation, Work with data

Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL FLOAT data type, you may have come...
Read More

Storing Binary Data Types in SQL Server

Database administation, Work with data

Introduction Daily work rarely requires storing binary data directly to database columns. However, it is very useful in some cases....
Read More

SQL Data Types: 5 Worst Choices You Need to Stop Today

Database administation, Work with data

Do your choices of SQL server data types and their sizes matter? The answer lies in the result you...
Read More
Close