[aprssig] APRS IS streams and MySQL

[Gregory A. Carter]

Hi Andrew,

Most MySQL libraries have functions called variations of "mysql_escape" that
will automatically escape characters like quotes.  Before any data is sent
from APRS-IS through our OpenAPRS parser and into mySQL all of the "control
code" characters are removed using REGEX replacements.

Greg

NV6G
OpenAPRS.Net

On Sat, Sep 12, 2009 at 9:01 AM, Andrew Rich (Home) <
vk4tec at tech-software.net> wrote:

>  As we know the APRS stream contains characters that MySQL or QUERY
> forming applications may not like.
>
> Just wondering how the big guns handle these ?
>
> Do you do a search and replace with an escape and re-parse on request ?
>
> The characters I can think of are quotes
>
>
>
>
> ----------------------------------------------------------
> Andrew Rich
> Airways Technical Officer Grade 4
> Surveillance - RADAR ADS-B
> Amateur Radio Callsign VK4TEC
> email: vk4tec at tech-software.net
> web: www.tech-software.net
>
> _______________________________________________
> aprssig mailing list
> aprssig at tapr.org
> https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/aprssig_lists.tapr.org/attachments/20090912/619c9891/attachment.html>