{"action":"opened","issue":{"url":"https://api.github.com/repos/quinnj/ODBC.jl/issues/83","labels_url":"https://api.github.com/repos/quinnj/ODBC.jl/issues/83/labels{/name}","comments_url":"https://api.github.com/repos/quinnj/ODBC.jl/issues/83/comments","events_url":"https://api.github.com/repos/quinnj/ODBC.jl/issues/83/events","html_url":"https://github.com/quinnj/ODBC.jl/issues/83","id":74504007,"number":83,"title":"querying a LONGBLOB or LONGTEXT causes ERROR: MemoryError()","user":{"login":"martinmev","id":1116040,"avatar_url":"https://avatars.githubusercontent.com/u/1116040?v=3","gravatar_id":"","url":"https://api.github.com/users/martinmev","html_url":"https://github.com/martinmev","followers_url":"https://api.github.com/users/martinmev/followers","following_url":"https://api.github.com/users/martinmev/following{/other_user}","gists_url":"https://api.github.com/users/martinmev/gists{/gist_id}","starred_url":"https://api.github.com/users/martinmev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinmev/subscriptions","organizations_url":"https://api.github.com/users/martinmev/orgs","repos_url":"https://api.github.com/users/martinmev/repos","events_url":"https://api.github.com/users/martinmev/events{/privacy}","received_events_url":"https://api.github.com/users/martinmev/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-05-08T21:36:34Z","updated_at":"2015-05-08T21:36:34Z","closed_at":null,"body":" julia> query(\"select data from users\")\r\nERROR: MemoryError()\r\nin ODBCColumnAllocate at /root/.julia/v0.3/ODBC/src/backend.jl:112\r\nin ODBCBindCols at /root/.julia/v0.3/ODBC/src/backend.jl:95\r\nin query at /root/.julia/v0.3/ODBC/src/userfacing.jl:53\r\nin query at /root/.julia/v0.3/ODBC/src/userfacing.jl:42\r\n\r\nThe column 'data'  has type 'longtext' (the maximal text size is 451 bytes in the column 'data'). ODBCColumnAllocate tries to allocate 4 GB (the size of the type longtext).\r\n\r\nPossible solutions:\r\n\r\na) Error message \"LONGBLOB and LONGTEXT types are not supported.\" if type size > 16777215 (mediumtext).\r\n\r\nb) To retrieve all columns via the method SQLGetData instead of binding columns (SQLBindCol).\r\n(Getting Long Data: https://msdn.microsoft.com/en-us/library/ms712426%28v=vs.85%29.aspx).\r\n\r\nJulia version 0.3.7 (Linux, unixodbc), 0.3.6 (Windows 7 64bit)\r\nODBC.jl version 0.3.10\r\nDatabase: MySQL"}}