List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2001 4:02am
Subject:Re: Removing Bad Characters from Database
View as plain text  
At 1:45 PM -0400 5/9/01, <joe@stripped> wrote:
>I was wondering if anyone knows of a way i can strip bad characters out
>of a mysql database field namely the < > charators. These charactors are
>causing havok for
>me when I try and post data to the web. Thanks Alot.

Why not just encode your data properly when you display it?
For example if you're using Perl and CGI.pm, use escapeHTML()
to escape any characters that are special in HTML before you
display them.

Or by "post", do you mean that you're having problems interpreting
the contents of a submitted form.

>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread73373@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, paul@stripped
Thread
Removing Bad Characters from Databasejoe9 May
  • Re: Removing Bad Characters from DatabaseEric Fitzgerald9 May
    • Re: Removing Bad Characters from DatabaseA. Chris Nichols9 May
      • RE: Removing Bad Characters from Databasejoe9 May
        • Having success with 20 million rowsDavid J. Potter9 May
          • Re: Having success with 20 million rowsJoshua J. Kugler9 May
          • Re: Having success with 20 million rowsChristian Jaeger9 May
            • Re: Having success with 20 million rowsPaul DuBois10 May
        • MySQL HAcarlos ospina9 May
          • RE: MySQL HABilly Passauer9 May
            • RE: MySQL HATyrone Mills9 May
            • Re: MySQL HAJeremy Zawodny9 May
            • RE: MySQL HARavi Raman9 May
              • Re: MySQL HAcarlos ospina9 May
                • Re: MySQL HAJeremy Zawodny10 May
            • Re: MySQL HACal Evans9 May
            • Re: MySQL HAJoshua J. Kugler9 May
          • Re: MySQL HAJeremy Zawodny9 May
        • Re: Having success with 20 million rowsErnesto Vargas9 May
  • Re: Removing Bad Characters from DatabasePaul DuBois10 May
RE: Having success with 20 million rowsRobert Henkel9 May
RE: Having success with 20 million rowsRobert Henkel9 May
  • Re: Having success with 20 million rowsZak Greant9 May
RE: MySQL HARobert Henkel9 May
RE: Having success with 20 million rowsRobin Keech10 May
RE: Having success with 20 million rowsJHDrexler10 May
RE: Having success with 20 million rowsJesper Frank Nemholt10 May