Top "Sqldatatypes" questions

How are varchar values stored in a SQL Server database?

My fellow programmer has a strange requirement from his team leader; he insisted on creating varchar columns with a length …

sql-server database sql-server-2008 database-design sqldatatypes

MySQL always returning BIT values as blank

From my create table script, I've defined the hasMultipleColors field as a BIT: hasMultipleColors BIT NOT NULL, When running an …

mysql sqldatatypes

Set the default value of a column based on another column of a different data type

I'm creating a new table in SQL table designer, and I'd like the "Default Value or Binding" of the column …

sql-server database-design sqldatatypes

Best technique to store gender in MySQL Database

Which is the best method to store gender in MY SQL Database? I am bit confused about this issue because …

mysql database sqldatatypes

What is an appropriate data type to store a timezone?

I'm thinking of simply using a string in the format "+hh:mm" (or "-hh:mm"). Is this both necessary and …

postgresql datetime timezone sqldatatypes

Default values for varchar and int mysql data types

The screenshot show 3 typical definitions of data type: id (autoincrement), a title and a number. 1.- Which are differences between: …

php mysql phpmyadmin default sqldatatypes

SQL 2008 - varchar(max) vs text data types

Possible Duplicate: SQL Server Text type vs. varchar data type Using varchar(MAX) vs TEXT on SQL Server from this …

sql sql-server-2008 varchar sqldatatypes varcharmax

Datatype to Store Longitude/Latitude in Mysql

'43.005895','-71.013202' Trying to use: INSERT INTO table(fanDetLocZip, fanDetLocCity, fanDetLocState, fanDetLocLat, fanDetLocLong, fanDetLocTZ, fanDetLocDST) VALUES(00210, 'Portsmouth', 'NH', …

mysql floating-point geospatial sqldatatypes

Is it okay to store money as decimal(22,2) in MySQL?

Is it okay to store money values as decimal(22,2) in MySQL? I am writing a web based marketplace and Ad …

mysql sqldatatypes

What Java data type corresponds to the Oracle SQL data type NUMERIC?

What Java data type does the Oracle JDBC driver assign to the Oracle SQL data type NUMERIC? Does this vary …

java sql oracle types sqldatatypes