I am trying to insert data into a newly created table with $result = db_insert('cc_npo_storage') ->fields(array( 'ein' => '$afields[0]',
table is defined * CREATE TABLE `cc_npo_storage` ( * `ein` varchar(10) NOT NULL,
The data I am inserting into field ein is ( '$afields[0]') Array[0] => 010759876
(I used the php command explode to take apart a delimited input string thus the array).
My problem is that I am getting the following message: *PDOException*: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'ein' at row 1: INSERT INTO {cc_npo_storage} (ein, name, city, state, country, tforeign, flagged, nid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => $afields[0] [:db_insert_placeholder_1] => $afields[1] [:db_insert_placeholder_2] => $afields[2] [:db_insert_placeholder_3] => $afields[3] [:db_insert_placeholder_4] => $afields[4] [:db_insert_placeholder_5] => $afields[5] [:db_insert_placeholder_6] => $afields[6] [:db_insert_placeholder_7] => $afields[7] ) in *insertdata()* (line *125* of * \sites\all\modules\custom\input\input.module*).
I have googled to no avail.
Thanks for any help Tony