IT Nursery
I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where the value of this column is...
What is the best SQL data type for currency values? I’m using MySQL but would prefer a database independent type. 9 Answers 9
I knew boolean in mysql as tinyint (1). Today I see a table with defined an integer like tinyint(2), and also others like int(4), int(6) … What does the...
What is the difference between varchar and varchar2? 6 Answers 6
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question...
Is there any Boolean type in Oracle databases, similar to the BIT datatype in Ms SQL Server? 11 Answers 11
I want to store many records in a MySQL database. All of them contains money values. But I don’t know how many digits will be inserted for each one....
What is the best practice for creating a yes/no i.e. Boolean field when converting from an access database or in general? 11 Answers 11
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 in the context of writing and...
Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I’m working with PHP on the server side. 40 40