From: Fred G Date: August 5 2012 3:14am Subject: DECIMAL datatype automatically makes blank become 0 List-Archive: http://lists.mysql.com/mysql/227948 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d042e005d577fd404c67c29c5 --f46d042e005d577fd404c67c29c5 Content-Type: text/plain; charset=ISO-8859-1 Hi-- I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank values become 0 when I define the datatype to be a DECIMAL (in our case (DECIMAL(12,2)). Since there is the potential for values to be 0, this poses a problem for us. I initially wanted to make all the DECIMAL values become VARCHAR(255), because I can still do inequality queries on this column if it is a VARCHAR, and VARCHAR does not mind blanks. It keeps them as is. But I'm sure that I must be missing something here. Is there a way to use a DECIMAL-like operator that treats blanks as blanks? If not, is there a better strategy then making the relevant column a VARCHAR? Much thanks! --f46d042e005d577fd404c67c29c5--