$wpdb->insert – Truncated Value

  • I am using $wpdb->insert to update content from a CSV file and everything i working perfectly except the phone numer. In the CSV file it say 215-545-9153 but when I insert the data into the database it only captures 215.

    I have the array format for that value set to string %s and the mysql value for that value is set to varchar(16) utf8_general_ci.

    I cannot understand why it truncates the value at the dash. I can’t find anything online with people having similar issues.

    I could sure use some feedback from someone smarter than me regarding this type of work.

    TIA.

Viewing 16 replies (of 16 total)
  • Thread Starter kokoruz

    (@kokoruz)

    I appreciate your help. I did resolve the one error but the truncation is still a mystery.

    Thanks again for looking through this with me.

Viewing 16 replies (of 16 total)
  • The topic ‘$wpdb->insert – Truncated Value’ is closed to new replies.