Top "Sqldatatypes" questions

Concerns data types used with SQL.

What is the datatype to store boolean value in MySQL?

Possible Duplicate: Which MySQL Datatype to use for storing boolean values? I am a .NET programmer and using MySQL database …

c# mysql types sqldatatypes
MySQL char & varchar character sets & storage sizes

Wondering how much actual storage space will be taken up by these two datatypes, as the MySQL documentation is slightly …

mysql character-encoding sqldatatypes
MySQL field type for weight and height data

What is the adequate MySQL field type for weight (in kilograms) and height (meters) data?

mysql sqldatatypes fieldtype
Performance difference between UUID, CHAR, and VARCHAR in PostgreSql table?

I'm storing UUID v4 values in a PostgreSQL v9.4 table, under column "id". When I create the table, is there …

sql postgresql database-performance sqldatatypes
postgres change data type of view column from unknown to text

I just create a new view as follows CREATE OR REPLACE VIEW gettreelistvw AS SELECT "CRM".groupid, 'pointrewarding'::text AS …

postgresql view sqldatatypes
Store CSS color values in DB

I need to store a CSS HEX color value (#FFFFFF for example) into a mysql database. Which type of data …

mysql types sqldatatypes
What SQL data type does Oracle assign to "count(*)"?

What SQL data type does Oracle assign to count(*) in a query like select count(*) from table? Does this depend …

sql oracle sqldatatypes
What is the Scala type mapping for all Spark SQL DataType

The different DataTypes available for Spark SQL can be found here. Can anyone please tell me what would be the …

sql scala apache-spark apache-spark-sql sqldatatypes
Best PostgreSQL datatype for storing key-value maps?

I'd like to store a simple map of key-value strings as a field in my PostgreSQL table. I intend to …

json postgresql sqldatatypes jsonb hstore
Importing CSV to SQL Server with text column > 8000 characters

I'm trying to import a csv file with two columns (sku, description) into SQL Server 2008 using the SQL Server management …

sql-server import ssms sqldatatypes truncation