Data truncation: Data too long for column 'Phone' at row 1

[smonline]

I am inserting data into temp table in MYSQL database.I have given size of 'Phone' column as VARCHAR(20) and have inserted data of exactly 10 character and it is constant.

Here is my code:

java.sql.PreparedStatement insertStmt = null;
 
                 String insertQuery = "insert into "+tableName+"(";
                 for(String col : columnList){
                             insertQuery+=col+",";
                         }
                insertQuery = insertQuery.substring(0,insertQuery.lastIndexOf(","));
                         insertQuery+=") values (";
                         for(String col : columnList){
                             insertQuery+="?,";
                         }
                insertQuery = insertQuery.substring(0,insertQuery.lastIndexOf(","));
                            insertQuery+=")";
                         insertStmt = mysqlConn.prepareStatement(insertQuery);
 
                while(rs.next())
                     {
                    for(int j=1;j<=columnList.size();j++)
                    {
                        insertStmt.setString(j,rs.getString(j).trim());
                        System.out.println(rs.getString(j).trim());
                    }
                    insertStmt.addBatch();
                    i++;
 
                    }
                insertStmt.executeBatch();    
 
                mysqlConn.setAutoCommit(true);
                rs = null;

and i am getting below error :

java.sql.BatchUpdateException: Data truncation: Data too long for column 'Phone' at row 1
Completed Temp tables 1&2
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:1269)
at com.mysql.jdbc.PreparedStatement.executeBatch(Prep aredStatement.java:955)
at MultipleDataExtraction.addDataToTempTable(Multiple DataExtraction.java:132)
at MultipleDataExtraction.addDataToFinalTempTable(Mul tipleDataExtraction.java:94)


Please help..

[Rabbit]

And what does the SQL string show after you build it but before you run it?