<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Ah thank you greg</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I did not know about that - i used to build it in
manually !</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Cheers </FONT></DIV>
<DIV>----------------------------------------------------------<BR>Andrew Rich
<BR>Airways Technical Officer Grade 4<BR>Surveillance - RADAR ADS-B<BR>Amateur
Radio Callsign VK4TEC<BR>email: <A
href="mailto:vk4tec@tech-software.net">vk4tec@tech-software.net</A><BR>web: <A
href="http://www.tech-software.net">www.tech-software.net</A></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=gcarter@openaprs.net href="mailto:gcarter@openaprs.net">Gregory A.
Carter</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=vk4tec@tech-software.net
href="mailto:vk4tec@tech-software.net">Andrew Rich (Home)</A> ; <A
title=aprssig@tapr.org href="mailto:aprssig@tapr.org">TAPR APRS Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, September 13, 2009 2:46
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [aprssig] APRS IS streams
and MySQL</DIV>
<DIV><BR></DIV>Hi Andrew,<BR><BR>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.<BR><BR>Greg<BR><BR>NV6G<BR>OpenAPRS.Net<BR><BR>
<DIV class=gmail_quote>On Sat, Sep 12, 2009 at 9:01 AM, Andrew Rich (Home)
<SPAN dir=ltr><<A
href="mailto:vk4tec@tech-software.net">vk4tec@tech-software.net</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV bgcolor="#ffffff">
<DIV><FONT size=2 face=Arial>As we know the APRS stream contains characters
that MySQL or QUERY forming applications may not like.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Just wondering how the big guns handle these
?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Do you do a search and replace with an escape
and re-parse on request ?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The characters I can think of are quotes
</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2
face=Arial>----------------------------------------------------------<BR>Andrew
Rich <BR>Airways Technical Officer Grade 4<BR>Surveillance - RADAR
ADS-B<BR>Amateur Radio Callsign VK4TEC<BR>email: <A
href="mailto:vk4tec@tech-software.net"
target=_blank>vk4tec@tech-software.net</A><BR>web: <A
href="http://www.tech-software.net"
target=_blank>www.tech-software.net</A></FONT></DIV></DIV><BR>_______________________________________________<BR>aprssig
mailing list<BR><A href="mailto:aprssig@tapr.org">aprssig@tapr.org</A><BR><A
href="https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig"
target=_blank>https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig</A><BR><BR></BLOCKQUOTE></DIV><BR>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.5.409 / Virus Database: 270.13.92/2364 - Release
Date: 09/11/09 17:51:00<BR></BLOCKQUOTE></BODY></HTML>