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:[EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]