Question : Let me state the obvious fist: I completely understand that floating point types cannot accurately represent decimal values. […]
Tag: floating-point
wrong value when storing big float value
Question : i got a weird problem using mariadb. CREATE DATABASE testdb; USE testdb; CREATE TABLE testing (afloat FLOAT NULL); […]
How to prepare a date and double for a mysql replace statement?
Question : I have a MySql table with three columns: CU VARCHAR(3) DA DATETIME VA DOUBLE I need to execute […]
PostgreSQL and MONEY data type for currency values
Question : For a project, I created a table with a column price MONEY NOT NULL column. And I thought […]
Selecting a floating value yields incorrect results
Question : Consider the following. CREATE TABLE IF NOT EXISTS `docs` ( `id` int(6) unsigned NOT NULL, `qty` float NOT […]
Biggest possible double/float for a column in my MySQL database
Question : I am developing a PHP application in which I am in need to store values bigger than 1 […]
Handling MySQL length=22 and decimals=31
Question : I’m using MySQL’s C api to determine the maximum possible value that can be stored in a specific […]
Convert a numeric column with number eg.(-1222222) to two float column with two decimal places eg (-12222.22)
Question : I know there are different variations of this question asked. But what I am trying to do is […]
Why does SQL Server convert floats to scientific notation?
Question : I came across some weird behavior: While passing a float value into a varchar column, the values are […]
Crazy automatic float rounding in MySQL 5.7 [duplicate]
Question : This question already has answers here: Biggest possible double/float for a column in my MySQL database (2 answers) […]
- 1
- 2