Top "Sqldatatypes" questions

Concerns data types used with SQL.

Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP on the …

mysql datetime timestamp sqldatatypes
Which MySQL data type to use for storing boolean values

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse' for storing true/false …

mysql boolean sqldatatypes
How do you create a yes/no boolean field in SQL server?

What is the best practice for creating a yes/no i.e. Boolean field when converting from an access database …

sql-server boolean sqldatatypes
SQL Server Text type vs. varchar data type

I have variable length character data and want to store in SQL Server (2005) database. I want to learn some best …

sql-server text varchar sqldatatypes
How to display two digits after decimal point in SQL Server

I have table which has a column of float data type in SQL Server I want to return my float …

sql-server sql-server-2008 sqldatatypes
How do I check if a SQL Server text column is empty?

I am using SQL Server 2005. I have a table with a text column and I have many rows in the …

sql-server sql-server-2005 sqldatatypes notnull emptydatatext
Is there any boolean type in Oracle databases?

Is there any Boolean type in Oracle databases, similar to the BIT datatype in Ms SQL Server?

sql database oracle boolean sqldatatypes
Best data type to store money values in MySQL

I want to store many records in a MySQL database. All of them contains money values. But I don't know …

mysql sqldatatypes currency
MySql: Tinyint (2) vs tinyint(1) - what is the difference?

I knew boolean in mysql as tinyint (1). Today I see a table with defined an integer like tinyint(2), and also …

mysql sqldatatypes