SQL Command - Insert string within the quotation mark limits to 2000 charater 
Author Message
 SQL Command - Insert string within the quotation mark limits to 2000 charater
As the tile.

Who knows how to overcome this problems --->

Insert into TABLE (Field1, Field2........) (Value 'Charaters more than
2000');

Tks/B.Rgds, Ricky



Fri, 12 Mar 2004 23:59:15 GMT
 SQL Command - Insert string within the quotation mark limits to 2000 charater

What version -
 how is the field defined -
 why not a separate insert for all the 'short' values and an update for the longer ones?
btw,
In 8i varchar2 can be 4000 chars...

Quote:

>As the tile.

>Who knows how to overcome this problems --->

>Insert into TABLE (Field1, Field2........) (Value 'Charaters more than
>2000');

>Tks/B.Rgds, Ricky

-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----


Sat, 13 Mar 2004 01:55:11 GMT
 SQL Command - Insert string within the quotation mark limits to 2000 charater
As of Oracle 8 you can have a varchar2 column of 4000 characters.  You might
also consider using a LONG column instead. Please give version info when
presenting problems especially if you know you are using a de-supported
version of Oracle

hth
Lawrence


Quote:
> As the tile.

> Who knows how to overcome this problems --->

> Insert into TABLE (Field1, Field2........) (Value 'Charaters more than
> 2000');

> Tks/B.Rgds, Ricky



Sat, 13 Mar 2004 07:55:45 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. TSQL String Constants containing quotation marks

2. -2147217900 Description: Unclosed quotation mark before the character string

3. ADO Cutting string (unclosed quotation mark before error)...

4. ADO Cutting string (unclosed quotation mark before error)...

5. Insert into quotation marks question

6. Single quotation marks issue in stored procedure with insert statement

7. Insert within a command object versus addnew within a recordset object

8. How can insert string with dingle quotation?

9. VB5, SQL, and Quotation marks...?...

10. SQL Quotation Marks

11. Quotation marks in SQL


 
Powered by phpBB® Forum Software