note 95118 added to function.odbc-binmode

For Sybase users (this probably applies to MS-SQL Server as well) who are using ODBC: I was using the same code as mizmerize, but I was getting truncated data back from the server (at the 32kb mark) when selecting data with the image datatype. My Sybase server has a @@textsize property of 2Gb, which should be plenty. But apparently, the php ODBC driver resets this to 32Kb when a connection is made, and then sets it back to 2Gb after. The solution is to do a query: odbc_exec($connH, "set textsize 131072"); immediately before your main query, in mizmerize's code. That should override the default setting. ---- Server IP: 85.19.212.230 Probable Submitter: 62.92.118.37 ---- Manual Page -- http://www.php.net/manual/en/function.odbc-binmode.php Edit -- https://master.php.net/note/edit/95118 Del: integrated -- https://master.php.net/note/delete/95118/integrated Del: useless -- https://master.php.net/note/delete/95118/useless Del: bad code -- https://master.php.net/note/delete/95118/bad+code Del: spam -- https://master.php.net/note/delete/95118/spam Del: non-english -- https://master.php.net/note/delete/95118/non-english Del: in docs -- https://master.php.net/note/delete/95118/in+docs Del: other reasons-- https://master.php.net/note/delete/95118 Reject -- https://master.php.net/note/reject/95118 Search -- https://master.php.net/manage/user-notes.php