TEXT Data Type

From: Sagine E(dot)Ferrus <sagine(at)islanderonline(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: TEXT Data Type
Date: 2002-11-19 17:00:28
Message-ID: 20021119170028.995E240AE@sitemail.everyone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi im using version 7.2, and im trying to insert very large strings into the TEXT field but i keep getting: parser error "000";
I noticed i get that error when the string is over 50-60 characters long, I thought the TEXT feild had no limit. Here is my code:

String sqlStr = "INSERT INTO news_articles VALUES
("'"+author+"', '"+title+"', '"+TheLargeString+"')";
PreparedStatement pstmt = con.prepareStatement(sqlStr);
pstmt.executeUpdate();

thanks in advance for the help
Sagine

_____________________________________________________________
Visit our Caribbean Community at http://www.islanderonline.com

_____________________________________________________________
Select your own custom email address for FREE! Get you(at)yourchoice(dot)com w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag

Browse pgsql-jdbc by date

  From Date Subject
Next Message Felipe Schnack 2002-11-19 17:11:19 Re: default values
Previous Message Felipe Schnack 2002-11-19 15:14:06 more about setDefault()