I want to store a long article in the Postgresql in Linux, how can I put the content into it and withdraw it back to show? urgent. Thanks. I use JSP. I note that all database systems are very dull in BLOB, but we need it to make a good system. At least, the documentation/faq should have much on it. thanks
Frank Zhu. ======================== "Bruce Momjian" <[EMAIL PROTECTED]> 写入消息新闻 :[EMAIL PROTECTED] > > On Wed, 10 Oct 2001, Aasmund Midttun Godal wrote: > > > > > I am sure this question has been answered in some form or another > > > before, but I can't really find anything on exactly this issue. > > > > > > Are there any differences between varchar and text other than > > > > > > 1. varchar has limited size > > > 2. varchar is SQL 92 text is not? > > > > > > Especially regarding performance. > > > > > > Or am I correct to assume that if you need a place to store some text, > > > and you are not sure how much (like an email address or a name) you > > > are best off using text? > > > > Pretty much yes. text and varchar are pretty equivalent other than > > the fact that varchar specifies a maximum size. > > I have added the following paragraph to the FAQ: > > <P>CHAR() is best when storing strings that are usually the > same length. VARCHAR() is best when storing variable-length strings, > but you want to limit how long a string can be. TEXT is for strings > of unlimited length, maximum 1 gigabyte. BYTEA is for storing > binary data, particularly values that include NULL bytes.</P> > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
