| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Quick Ingres r3 puzzle for you, I'm trying to load 32,000 bytes into a long varchar field. I'm not using embedded sql, I'm using the python dbi driver. It seems however that there is a limit to the size of a literal that can be used, which appears to be roughly around 28,000 characters when used in an INSERT statment... i.e. INSERT INTO sometable VALUES ('28,000 character literal ..... ') throws a DATABASE EXCEPTION (ingresdbi.DataError). The documentation suggests that there is a string literal max len of 2,000 characters, but that limitation does not appear to be present in practice - Here's a quote from the SQL reference Guide: "A literal of more than 2000 bytes cannot be assigned to a long byte column. For details about assigning long values to long byte columns, see the description of data handlers in the Embedded SQL Companion Guide..." It seems that data handlers are not an option in the non-embedded environment, so how can I upload a 64Kb file into a long varchar field from python ? Kind Regards, Morgan. |
![]() |
| Thread Tools | |
| Display Modes | |