I read that the data type can be used to store files. According to MySQL manual page on Blob, A BLOB is a binary large object that can hold a variable amount of data. Since it’s a data type specific to store binary data it’s common to use it to store files in binary format, … Read more
regular 4 byte INT is way too big, is a waste of space! You don’t say what database you’re using, so I can’t recommend a specific datatype. Everyone is saying “use integer”, but most databases store integers as 4 bytes, which is way more than you need. You should use a two byte integer (smallint … Read more
select cast(your_float_column as decimal(10,2)) from your_table decimal(10,2) means you can have a decimal number with a maximal total precision of 10 digits. 2 of them after the decimal point and 8 before. The biggest possible number would be 99999999.99
Try to use ColumnAttribute from System.ComponentModel.DataAnnotations (defined in EntityFramework.dll): [Column(TypeName=”Date”)] public DateTime ReportDate { get; set; }
SELECT column_name, data_type FROM information_schema.columns WHERE table_name=”table_name”; with the above query you can columns and its datatype
The equivalent is a BIT field. In SQL you use 0 and 1 to set a bit field (just as a yes/no field in Access). In Management Studio it displays as a false/true value (at least in recent versions). When accessing the database through ASP.NET it will expose the field as a boolean value.
The (m) indicates the column display width; applications such as the MySQL client make use of this when showing the query results. For example: | v | a | b | c | +—–+—–+—–+—–+ | 1 | 1 | 1 | 1 | | 10 | 10 | 10 | 10 | | 100 | … Read more
They are the same. Numeric is functionally equivalent to decimal. MSDN: decimal and numeric
I found this link useful. Here is the paragraph highlighting some of the pros/cons of each approach. The most commonly seen design is to imitate the many Boolean-like flags that Oracle’s data dictionary views use, selecting ‘Y’ for true and ‘N’ for false. However, to interact correctly with host environments, such as JDBC, OCCI, and … Read more
The equivalent is a BIT field. In SQL you use 0 and 1 to set a bit field (just as a yes/no field in Access). In Management Studio it displays as a false/true value (at least in recent versions). When accessing the database through ASP.NET it will expose the field as a boolean value.