How to create a yes/no boolean field in SQL server?
The equivalent is a BIT field. In SQL you use 0 and 1 to set a bit field (just as a yes/no field … Read more
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 table where … Read more
Best data type for storing currency values in a MySQL database
What is the best SQL data type for currency values? I’m using MySQL but would prefer a database independent type. 9 Answers 9
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 others like … Read more
What is the difference between varchar and varchar2 in Oracle?
What is the difference between varchar and varchar2? Best Answer 6
SQL Server Text type vs. varchar data type [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, … Read more
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? 1Best Answers 11
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 how many digits … Read more
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 or in general? 1Best Answers … Read more
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 information in MySQL? Especially … Read more
