Re: Eliminating character sets from DB entry
| From: | Michelle Konzack | Date: | Tue, 02 May 2006 19:13:49 +0000 |
| Subject: | Re: Eliminating character sets from DB entry | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41819@lists.php.net to get a copy of this message | ||
Am 2006-04-30 19:59:06, schrieb Chris Payne:
> Hi there everyone,
>
> Is there a way to allow Only English character sets in database entry with
> MySQL and PHP? I'm getting an awful lot of SPAM which is in
> Chinese/Japanese and i'd love to be able to block these charactersets from
> being inserted into my databases.
???
If you store your Messages in a MySQL database, the script, which store
the messages schould check the "Content-Type:" Header before inserting.
And second, you should roun spamassassin/spamc on each message before
passing the message to the script...
This two advices should you save some headache...
Note: I have now over 7 million messages in my PostgreSQL
and to 99,999% spamfree
(using fetchmail, procmail and a php5 script).
Greetings
Michelle Konzack
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)