Eliminating character sets from DB entry

------=_NextPart_000_0083_01C66C90.8A1C51C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.

Chris

------=_NextPart_000_0083_01C66C90.8A1C51C0--

Re: Eliminating character sets from DB entry

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)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Eliminating character sets from DB entry

trap the IP and do a lookup on some service to detmine the origin of the
user...if not from the country(ies) you want to serve redirect that user
away to some other page or provide a custom 404 page to mess with the bots

bastien


>From: "Chris Payne"
>To:
>Subject: [PHP-DB] Eliminating character sets from DB entry
>Date: Sun, 30 Apr 2006 19:59:06 -0400
>
>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.
>
>Chris

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php