You need to escape the data read from the form. I'm sure that whatever
programming language you are using has some function to do this.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com

> -----Original Message-----
> From: Hiep Nguyen [mailto:hiep@ee.ucr.edu]
> Sent: Monday, December 03, 2007 3:09 PM
> To: mysql@lists.mysql.com
> Subject: speical characters in text column
>
> hi friends,
>
> i searched on google but not file a solution.
>
> is there a way that i can store special characters (return, new line,
> tab,
> etc) into mysql (ver. 4.1.12) table with text type?
>
> i use textarea tag for user to enter the text.
>
> my goal is to store/display EXACTLY what user entered in the textarea
> tag.
>
> Thanks,
> T. Hiep
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartz@the-
> infoshop.com