Skip site navigation (1) Skip section navigation (2)

Re: Textarea returns

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: operationsengineer1(at)yahoo(dot)com
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Textarea returns
Date: 2005-04-30 14:31:45
Message-ID: 20050430143145.GA48753@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, Apr 29, 2005 at 10:42:11PM -0700, operationsengineer1(at)yahoo(dot)com wrote:
>
> i use a form textarea to insert data into a varchar
> pgsql column.  i noticed that a carriage return
> character gets stored in pgsql.  it looks like an
> infinity symbol laying on its side.
> 
> how do i prevent this?

What do you want to happen instead?  If you don't want the carriage
return stored then strip it from the input data; if you want it
stored but not displayed, then strip it from the output data or
convert it to something else.  Can you be more specific about how
you're accessing the database and what you'd like to do?

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

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-04-30 15:48:26
Subject: Re: Problem with DirectFunctionCall3(array_in,...)
Previous:From: operationsengineer1Date: 2005-04-30 05:42:11
Subject: Textarea returns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group