{"action":"created","issue":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/120","repository_url":"https://api.github.com/repos/ibmdb/node-ibm_db","labels_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/120/labels{/name}","comments_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/120/comments","events_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/120/events","html_url":"https://github.com/ibmdb/node-ibm_db/issues/120","id":157025090,"number":120,"title":"Error inserting file to BLOB column","user":{"login":"dhaazen","id":11396857,"avatar_url":"https://avatars.githubusercontent.com/u/11396857?v=3","gravatar_id":"","url":"https://api.github.com/users/dhaazen","html_url":"https://github.com/dhaazen","followers_url":"https://api.github.com/users/dhaazen/followers","following_url":"https://api.github.com/users/dhaazen/following{/other_user}","gists_url":"https://api.github.com/users/dhaazen/gists{/gist_id}","starred_url":"https://api.github.com/users/dhaazen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhaazen/subscriptions","organizations_url":"https://api.github.com/users/dhaazen/orgs","repos_url":"https://api.github.com/users/dhaazen/repos","events_url":"https://api.github.com/users/dhaazen/events{/privacy}","received_events_url":"https://api.github.com/users/dhaazen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2016-05-26T16:29:17Z","updated_at":"2016-06-18T20:35:04Z","closed_at":null,"body":"I have a file that is assigned to a variable as a buffer and I'm trying to insert into my table which has the BLOB data type. \r\n\r\n```\r\n    conn.prepare('SELECT id FROM NEW TABLE(INSERT INTO support_document ('+\r\n    'document_data,'+\r\n    'mime_type,'+\r\n    'support_document_type_id'+\r\n    ') VALUES(?,?,?))', function(err, stmt) {\r\n\r\n      stmt.execute([\r\n        supportDocuments[i].buffer,\r\n        supportDocuments[i].mimetype,\r\n        supportDocumentLabels[i]\r\n      ], function(err, result) {\r\n        if(err){\r\n          console.log(err);\r\n        } else {\r\n\r\n```\r\n\r\nWhen this executes I get the following error:\r\n\r\n```\r\n{ [Error: [IBM][CLI Driver] CLI0123E  SQL data type out of range. SQLSTATE=HY004]\r\n  errors: [],\r\n  error: '[node-odbc] SQL_ERROR',\r\n  message: '[IBM][CLI Driver] CLI0123E  SQL data type out of range. SQLSTATE=HY004',\r\n  state: 'HY004' }\r\n```\r\n\r\nI was able to do a very similar insert into a postgres DB. Please advise"},"comment":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/comments/226963517","html_url":"https://github.com/ibmdb/node-ibm_db/issues/120#issuecomment-226963517","issue_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/120","id":226963517,"user":{"login":"dhaazen","id":11396857,"avatar_url":"https://avatars.githubusercontent.com/u/11396857?v=3","gravatar_id":"","url":"https://api.github.com/users/dhaazen","html_url":"https://github.com/dhaazen","followers_url":"https://api.github.com/users/dhaazen/followers","following_url":"https://api.github.com/users/dhaazen/following{/other_user}","gists_url":"https://api.github.com/users/dhaazen/gists{/gist_id}","starred_url":"https://api.github.com/users/dhaazen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhaazen/subscriptions","organizations_url":"https://api.github.com/users/dhaazen/orgs","repos_url":"https://api.github.com/users/dhaazen/repos","events_url":"https://api.github.com/users/dhaazen/events{/privacy}","received_events_url":"https://api.github.com/users/dhaazen/received_events","type":"User","site_admin":false},"created_at":"2016-06-18T20:35:03Z","updated_at":"2016-06-18T20:35:03Z","body":"@bimalkjha Sorry, but I'm not sure what you mean by platform..."}}
{"actor":{"display_login":"dhaazen"}}