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 not null, but it is empty. Trying to compare against ” yields this response: The data types text and varchar are incompatible in the not equal … Read more
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 size means in field of type integer and tinyint ? 4 Answers 4
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 will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
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. Which data type do I have to use for this purpose? VARCHAR or INT (or other numeric data types)? 12 Answers 12
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 reading from/to a PHP script. Over time I have used and seen several approaches: tinyint, varchar fields containing the values 0/1, varchar fields containing the strings … Read more
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
