title: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value
body: <p>in my decimal from WAMP server is decimal (5,2)
  My QueryException:</p>
  
  <p>SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'converted_1000ml' at row 1 (SQL: insert into <code>inventory_databanks</code> (<code>product_desc</code>, <code>nc_os</code>, <code>ncos_value</code>, <code>del</code>, <code>ei</code>, <code>sa</code>, <code>wh</code>, <code>bi</code>, <code>brand</code>, <code>variant</code>, <code>type</code>, <code>content</code>, <code>conversion_1000ml</code>, <code>**converted_1000ml**</code>, <code>os</code>, <code>bo</code>, <code>peso_sales</code>, <code>bo_case</code>, <code>os_case</code>, <code>del_case</code>, <code>wh_case</code>, <code>sa_case</code>, <code>price</code>, <code>facing</code>, <code>maker</code>, <code>merchandiser_name</code>, <code>complete_address</code>, <code>source_type</code>, <code>payroll_period</code>, <code>cellphone</code>, <code>schedule</code>, <code>area</code>, <code>region</code>, <code>province</code>, <code>city_municipality</code>, <code>outlet</code>, <code>edi_branch</code>, <code>salesman</code>, <code>ns_case1</code>, <code>ns_case2</code>, <code>ns_case3</code>, <code>ns_bottles1</code>, <code>ns_bottles2</code>, <code>ns_bottles3</code>, <code>ns_date1</code>, <code>ns_date2</code>, <code>ns_date3</code>, <code>date_started</code>, <code>inventory_date</code>, <code>updated_at</code>, <code>created_at</code>) values (Emperador_Light 1000mL Light Brandy, With Stocks, With Stocks, <strong>2400</strong>, 4734, 78, <strong>4656</strong>, 245, Emperador_Light, Brandy, Original, 1000, 1.00, 4734.00, 0, 0, -229790, 0, 0, 0, 0, 0, 110.00, 13, EDI, Rodolfo Siongco Jr, null, From Inventory Sheet, 01/16/2018 - 01/31/2018, 09303243249, T-TH-S, Central Luzon, Region III, Bataan, Mariveles, CORA'S, Pampanga Branch, Angelito Quetua, 0, 0, 0, 0, 0, 0, 2018-01-31, 2018-01-31, 2018-01-31, 2018-01-16, 1970-01-01, 2018-02-08 08:49:48, 2018-02-08 08:49:48))</p>
  
  <p>How can i fix this? bold numbers i think this is my problem</p>