Question : Let’s assume I want to store phone numbers in a database. I may accept phone numbers from outside […]
Tag: datatypes
Use of ANY function for multiple values
Question : I am trying to use the ANY function of PostgreSQL to search the value from array interger type […]
Does a numeric field always use the same disk space?
Question : When you have a numeric field in MySQL(MYISAM) (E.g. Integer) will it always use the same disk space, […]
Best SQL datatype for JSON
Question : In SQL Server 2016, I believe the best datatype for handling JSON is nvarchar. Most of our JSON […]
Why ‘t’ and ‘f’ instead of TRUE and FALSE
Question : Why does PostgreSQL return ‘t’ and ‘f’ instead of TRUE and FALSE? The documentation itself advises us to […]
Converting columns from NVARCHAR to VARCHAR
Question : I have several large tables with many NVARCHAR(MAX) columns. This database is only for US use and I […]
Changing TEXT to VARCHAR
Question : In a MySQL database (InnoDB) we have a table containing roughly 60.000.000 rows. One of the columns is […]
Float datatype with 2 digits after decimal point
Question : In SQL server float datatype does not display trailing zeros after decimal point declare @num as float set […]
Good layout of 3d point data for spatial queries in Postgres?
Question : Like shown in another question, I deal with a lot (>10,000,000) entries of points in a 3D space. […]
How can I convert from Double Precision to Bigint with PostgreSQL?
Question : I need to convert a value of Double Precision to Bigint with PostgreSQL. How can I do that? […]