Unix Technical Forum

Re: inset html data into text column

This is a discussion on Re: inset html data into text column within the pgsql Novice forums, part of the PostgreSQL category; --> On Thu, Apr 14, 2005 at 10:28:39AM +0100, rui.justino wrote: > > I have a table with a column ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:43 PM
Michael Fuhr
 
Posts: n/a
Default Re: inset html data into text column

On Thu, Apr 14, 2005 at 10:28:39AM +0100, rui.justino wrote:
>
> I have a table with a column of type text with no limitation of
> caracters, that i'm trying to insert html formatted text into but
> the text gets truncated.


How are you inserting the HTML? How are you determining that the
text is truncated? How many characters are in the truncated text?
Have you used length() to see how much text is in the table? Is
it possible that all the text is there and the client is truncating
it for output?

> for the moment i have tested with psycopg, pgsql and pgAdmin III.
> always getting the same result.


I don't use pgAdmin but I recall people saying that it truncates
output. Are you sure the psycopg and psql (? -- you said "pgsql")
tests are correct? Could you post a simple test case that shows
exactly what you did?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:40 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com