I would say it depends on what you're using to put the data into your
database.
PHP comes with several functions that make this sort of thing very easy
(strip_tags, for example, will remove all HTML tags from a string)
If you're using Perl or something else that supports regex, I think that's
going to have to be the best way.
HTH
Jon
-----Original Message-----
From: Selvin Sakal [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 12:43
To: [EMAIL PROTECTED]
Subject: characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that cannot be
entered into mysql (like !@#$%, etc).
Also i have a string and i would like to remove html tags, characters (like
~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want the string
to be just left with words.
any help would be helpful,
Thanks
Selvin
P.S. this is urgent i need this very quickly
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**********************************************************************
'The information included in this Email is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee,
any disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or
confidentiality'
**********************************************************************
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
