Questions tagged [datatypes]
Specifies the type of data being stored (string, date, numeric, etc).
458
questions
5
votes
3answers
2k views
Migrating from NTEXT to NVARCHAR(MAX)
I have table with the columns of type NTEXT. And for some peculiar reasons, the client wants to migrate the column type to NVARCHAR(MAX).
While doing so, what all potential threat should I be careful ...
3
votes
3answers
2k views
Estimate large database size and speed
First I want to know how to estimate the database size regarding the biggest table it will contains. I've the following :
+----------+------------------+------+-----+---------+-------+
| Field | ...
12
votes
4answers
11k views
MySQL data type for 128 bit integers
I need to store 128 bits unsigned integers into MySQL and I was wondering what is the best data type to store such big numbers.
Right now, I'm using binary(16) but that involves a lot of conversion ...
6
votes
2answers
2k views
Get records between time span
I would like to retrieve records between time spans,All i have is this snippet of string indicating the time span
9:00 AM - 10:00 AM
below is the table schema
CREATE TABLE [dbo].[Samples](
[RID] [...
54
votes
6answers
27k views
Performance implications of MySQL VARCHAR sizes
Is there a performance difference in MySQL between varchar sizes? For example, varchar(25) and varchar(64000). If not, is there a reason not to declare all varchars with the max size just to ensure ...
21
votes
2answers
38k views
What is the difference between MySQL VARCHAR and TEXT data types?
After version 5.0.3 (which allowed VARCHAR to be 65,535 bytes and stopped truncating trailing spaces), is there any major difference between these two data types?
I was reading the list of ...
30
votes
1answer
55k views
INT(5) vs SMALLINT(5): numbers in parenthesis after the numeric type
In MySQL table definitions is there a different between INT(5) and SMALLINT(5)? Or do they both represent the same size?
65
votes
3answers
39k views
What are the drawbacks with using UUID or GUID as a primary key?
I would like to build a distributed system. I need to store data in databases and it would be helpful to use an UUID or a GUID as a primary key on some tables. I assume it's a drawbacks with this ...
