A question about a SQL with a quoted string exceeds 256 bytes on Informix
843854May 22 2002 — edited May 23 2002I don't know how does the IfxPrepearStatment works. when i spelling a SQL insert string what a quoted string exceeds 256 bytes(as a column in table) in it , just as '01234567890....',the Informix server return a -280 error as 'A quoted string exceeds 256 bytes', but when i use ODBC , the error will not return, i think the ODBC had prepear parsed the SQL string and sent the each variables to Informix server. ESQL/C can escape the error too. I thought that the ec compile the programe to use the Informix API directly and send the each variables directly.When I use Java JDBC , I can't escape this error , please give me some advice .
My English is very poor , beg pardon.
thanks very much!