INSERT INTO a LONG datatype

From: Matthew Appler <mappler_at_cynacom.com>
Date: 1996/03/25
Message-ID: <4j77mq$snr_at_news.cais.com>#1/1

I am trying to insert data into a table in a column that is a LONG. I have met with marginal success and I believe the problem is that I am formulating my SQL statement incorrectly.

For example, if I enter the following statement:

INSERT INTO tablename
VALUES (254, 'Test', 'This is the long value');

It works just fine (assuming the last column is the long column). However, if the last string is > 2000 bytes I get an error that the string literal is too long. ie: if I quote more than 2000bytes, it doesn't work.

Therefore, how do I insert more than 2000 bytes???? Any help would be greatly appreciated...

Thank you very much,
  Matthew Appler

---

Matthew A. Appler
mappler_at_cygnacom.com
CyngaCom Solutions, Inc.
(703)848-0883

Visit our WEB PAGE! http://www.cygnacom.com NOTE: Views expressed belong to me, not my employer Received on Mon Mar 25 1996 - 00:00:00 CET