datatypes

I want to store scientific notation numbers in MySql. I've saved them to a field which has datatype decimal . The issue is that it stores it in…

Running Postgres 7.4 (Yeah we are in the midst of upgrading) I need to store from 1 to 100 selected items into one field in a database. 98% of the…

I am trying to put together an SQL database but don't really know how to make it work. The intention is to have multiple columns, some with…

In Table_1, I have imported data from a spreadsheet. In one table column there are mixed values: 94.7, 45.0, 36, car, bus....etc. The datatype is…

I'm looking at a db schema for a project I'm inheriting. There are many instances of binary answers being stored as INT(11) rather than TinyInt(1),…

I have a MySQL database that uses the Set datatype. I'd like to construct a query that will output the most frequently occurring element. so…

I have to store isdCodes which is in format 0091 001 009751 009665 etc. in the database, the initial will basically start from zero. i tried using…

Hello, I have a facebook app that stores users info after allowing access. I'm storing almost everything, but because my app is growing fast, I must…

I want to store the values of latitude and longitude fetched from Google Maps GeoCoding API in a MySQL database. The values are in float format.…

Hello everyone, This maybe an easy one but i couldn't get answer. I need to select float value from table example table :- value 10.2 4.5 4.6 4.06…

In MySQL does the storage requirement for INT datatype varies with the actual value stored in the table?

I want to store my image data into my mysql database or table. What appropriate data type in mysql should I use to store the image data?

I created a table as follows: create table employers ( id integer primary key, name string, surname string, description string ); I noticed here…

Is there a data type in Rails ActiveRecord migrations that maps to tinyint in mysql.

I have a function that is suppose to store variables based on their datatype, and this is table I have come up with to store those variables into. I…

I am a .NET programmer and using MySQL database for the first time in my life. I wanted to store boolean value, MySQL has BIT , but the .NET…

In the MySQL manual Data Type Storage Requirements , I found: Data Type Storage Required -------------------------------------------- TINYTEXT L + 1…

Difference between TinyInt / SmallInt / MediumInt / Int / BigInt in MySQL data type ? I want to use an [unsigned] integer field with 11 length, what…

I need a field in my table to store some text. 300 characters is the limit for the text. What is the best choice the option: varchar (300) or text ?

I want to store a hashed password (using BCrypt) in a database. What would be a good type for this, and which would be the correct length? Are…