assigning values to long varchar's using string literals over 28,000chars long

This is a discussion on assigning values to long varchar's using string literals over 28,000chars long within the Ingres Database forums in Other Databases category; 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 ...

Go Back   Database Forum > Other Databases > Ingres Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 01-03-2006, 12:05 PM
Default assigning values to long varchar's using string literals over 28,000chars long

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.


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 09:18 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.