sqldatatypes Archives

Programming, sql-server

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 ...

MySQL, Programming

IT Nursery

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 ...

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, ...

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 ...

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 ...

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 ...

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I’m working with PHP on the server side. 40 ...