{"id":39,"date":"2009-02-21T16:59:00","date_gmt":"2009-02-21T16:59:00","guid":{"rendered":"http:\/\/www.olivierdoucet.info\/wordpress\/?p=39"},"modified":"2009-02-21T16:59:00","modified_gmt":"2009-02-21T16:59:00","slug":"stockage-de-nombre-a-virgules-dans-mysql","status":"publish","type":"post","link":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/","title":{"rendered":"Stockage de nombre \u00e0 virgules dans MySQL"},"content":{"rendered":"<p>Pour stocker un nombre \u00e0 virgule (un flottant, ou float en anglais) dans MySQL, il existe plusieurs types de colonnes. Mais attention : ils ne sont pas tous identiques. Petite d\u00e9monstration simple : %%% * Prenons une table &lsquo;test&rsquo;, avec entre autre un champ de type FLOAT(8,2). * Executez la requete suivante : %%% @@INSERT INTO `test` (id, flottant) VALUES(4,&rsquo;446351.74&prime;);@@ %%% * Puis relisez la ligne : @@SELECT * FROM `test` WHERE id=4@@ Voici le r\u00e9sultat:%%% @@446351.75@@ Comment ?? ,75 et non ,74 comme je l&rsquo;ai demand\u00e9 ? Et oui, normal vu la m\u00e9thode de stockage qu&rsquo;utilise MySQL.<br \/>\n<!--more--><br \/>\nVoici ce que dit la doc : >\u00a0\u00bb Les types NUMERIC et DECIMAL  [&#8230;] sont utilis\u00e9es par des valeurs dont il est primordial de conserver la pr\u00e9cision exacte, comme pour des donn\u00e9es financi\u00e8res.\u00a0\u00bb > La pr\u00e9cision d&rsquo;un FLOAT n&rsquo;est donc pas parfaite. Faites attention \u00e0 \u00e7a si vous stockez des valeurs financi\u00e8res dans une base de donn\u00e9es. je vous encourage donc \u00e0 aller lire attentivement la documentation lors de la cr\u00e9ation de vos tables \ud83d\ude09 [http:\/\/dev.mysql.com\/doc\/refman\/5.0\/fr\/numeric-type-overview.html|http:\/\/dev.mysql.com\/doc\/refman\/5.0\/fr\/numeric-type-overview.html|fr]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pour stocker un nombre \u00e0 virgule (un flottant, ou float en anglais) dans MySQL, il existe plusieurs types de colonnes. Mais attention : ils ne sont pas tous identiques. Petite d\u00e9monstration simple : %%% * Prenons une table &lsquo;test&rsquo;, avec entre autre un champ de type FLOAT(8,2). * Executez la requete suivante : %%% @@INSERT INTO `test` (id, flottant) VALUES(4,&rsquo;446351.74&prime;);@@ %%% * Puis relisez la ligne : @@SELECT * FROM `test` WHERE id=4@@ Voici le r\u00e9sultat:%%% @@446351.75@@ Comment ?? ,75 et non ,74 comme je l&rsquo;ai demand\u00e9 ? Et oui, normal vu la m\u00e9thode de stockage qu&rsquo;utilise MySQL.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[43,36],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-php-sql","tag-float","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Stockage de nombre \u00e0 virgules dans MySQL - My thoughts<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stockage de nombre \u00e0 virgules dans MySQL - My thoughts\" \/>\n<meta property=\"og:description\" content=\"Pour stocker un nombre \u00e0 virgule (un flottant, ou float en anglais) dans MySQL, il existe plusieurs types de colonnes. Mais attention : ils ne sont pas tous identiques. Petite d\u00e9monstration simple : %% @@INSERT INTO `test` (id, flottant) VALUES(4,&#039;446351.74&#039;);@@ %% @@446351.75@@ Comment ?? ,75 et non ,74 comme je l&#039;ai demand\u00e9 ? Et oui, normal vu la m\u00e9thode de stockage qu&#039;utilise MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"My thoughts\" \/>\n<meta property=\"article:published_time\" content=\"2009-02-21T16:59:00+00:00\" \/>\n<meta name=\"author\" content=\"olivier\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@odoucet\" \/>\n<meta name=\"twitter:site\" content=\"@odoucet\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"olivier\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/\",\"url\":\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/\",\"name\":\"Stockage de nombre \u00e0 virgules dans MySQL - My thoughts\",\"isPartOf\":{\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/#website\"},\"datePublished\":\"2009-02-21T16:59:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/#\/schema\/person\/2a02230ae6aeac086b3379e5853c6f96\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.olivierdoucet.info\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stockage de nombre \u00e0 virgules dans MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/#website\",\"url\":\"https:\/\/www.olivierdoucet.info\/blog\/\",\"name\":\"My thoughts\",\"description\":\"En fran\u00e7ais and in english :)\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.olivierdoucet.info\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/#\/schema\/person\/2a02230ae6aeac086b3379e5853c6f96\",\"name\":\"olivier\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.olivierdoucet.info\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/febd16d726b2266a512e951d03424de3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/febd16d726b2266a512e951d03424de3?s=96&d=mm&r=g\",\"caption\":\"olivier\"},\"sameAs\":[\"http:\/\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Stockage de nombre \u00e0 virgules dans MySQL - My thoughts","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/","og_locale":"fr_FR","og_type":"article","og_title":"Stockage de nombre \u00e0 virgules dans MySQL - My thoughts","og_description":"Pour stocker un nombre \u00e0 virgule (un flottant, ou float en anglais) dans MySQL, il existe plusieurs types de colonnes. Mais attention : ils ne sont pas tous identiques. Petite d\u00e9monstration simple : %% @@INSERT INTO `test` (id, flottant) VALUES(4,'446351.74');@@ %% @@446351.75@@ Comment ?? ,75 et non ,74 comme je l'ai demand\u00e9 ? Et oui, normal vu la m\u00e9thode de stockage qu'utilise MySQL.","og_url":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/","og_site_name":"My thoughts","article_published_time":"2009-02-21T16:59:00+00:00","author":"olivier","twitter_card":"summary_large_image","twitter_creator":"@odoucet","twitter_site":"@odoucet","twitter_misc":{"\u00c9crit par":"olivier","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/","url":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/","name":"Stockage de nombre \u00e0 virgules dans MySQL - My thoughts","isPartOf":{"@id":"https:\/\/www.olivierdoucet.info\/blog\/#website"},"datePublished":"2009-02-21T16:59:00+00:00","author":{"@id":"https:\/\/www.olivierdoucet.info\/blog\/#\/schema\/person\/2a02230ae6aeac086b3379e5853c6f96"},"breadcrumb":{"@id":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.olivierdoucet.info\/blog\/2009\/02\/21\/stockage-de-nombre-a-virgules-dans-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.olivierdoucet.info\/blog\/"},{"@type":"ListItem","position":2,"name":"Stockage de nombre \u00e0 virgules dans MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.olivierdoucet.info\/blog\/#website","url":"https:\/\/www.olivierdoucet.info\/blog\/","name":"My thoughts","description":"En fran\u00e7ais and in english :)","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.olivierdoucet.info\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.olivierdoucet.info\/blog\/#\/schema\/person\/2a02230ae6aeac086b3379e5853c6f96","name":"olivier","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.olivierdoucet.info\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/febd16d726b2266a512e951d03424de3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/febd16d726b2266a512e951d03424de3?s=96&d=mm&r=g","caption":"olivier"},"sameAs":["http:\/\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":0,"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/posts\/39\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/categories?post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.olivierdoucet.info\/blog\/wp-json\/wp\/v2\/tags?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}