Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PSQL text vs. varchar(n)

Status
Not open for further replies.

pennstump

Technical User
Nov 6, 2003
12
US
I am having a problem with Java Studio Creator because the latest version of the JDBC driver returns a field length of -1 for text fields.

My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want to use the data binding part of the JSC tool I will need to convert my text fields to some standard SQL data type. I understand that varchar just stores the actual length of the field. Would anyone recommend for or against creating a field of varchar(Integer.MAX_VALUE)? If against, how is text implemented and how can I represent it in a SQL standard format?

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top