On Fri, Apr 29, 2005 at 10:42:11PM -0700, operationsengineer1@yahoo.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/