5

DB2 'The string constant beginning with...is too long' error when inserting 40000 characters to CLOB(50000) field

view full story
linux-howto

http://serverfault.com – I have created a CLOB(50000) field in a DB2 table, and verified it has correctly created with DB2 DESCRIBE TABLE dbname ...however I received the following error message even when only attempting to insert a 40,000 character string into the field: [IBM][CLI Driver][DB2/LINUXX8664] SQL0102N The string constant beginning with "'''Testing Long Notes! Testing Long Notes! Testing Long Notes! Testing" is too long. SQLSTATE=54002 SQLCODE=-102 'Testing Long Notes!' is just the string I repeated over and over in the HTML field in order to build the 40,000 string length. PHP script then pro (HowTos)