<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=701182012-07062007>Hello
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=701182012-07062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=701182012-07062007>I am using
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=701182012-07062007>modparam("unixodbc",
"use_escape_common", 1)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=701182012-07062007>and the result is
that if I have a string like he'llo (single quote between the e and l), it
becomes he\'llo which is not working in sql. The result should be he''llo (two
single quotes between e and l). The reason is that unixodbc uses the core
function escape_common(). I think that unixodbc whould have two parameters
like</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT
size=2>modparam("unixodbc", "use_escape_character",
"'")</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT
size=2>modparam("unixodbc", "escaped_characters",
"'\%^")<BR>use_escape_character would be null by default and if it is not null
it would be the character to use for escaping.</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT
size=2>escaped_characters would be a list of characters that should be escaped
by the character defined above.</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT size=2>I have patched
unixodbc to use its own escape function instead, but it would be nice if this
was a configurable option that others could use. I could try to implement this
if there is an interest. Please let me know your
thoughts.</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT size=2>thank
you</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=701182012-07062007><FONT size=2>George</DIV>
<DIV><BR></DIV></FONT></SPAN></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY><!--[object_id=#altectelecoms.gr#]--><FONT face=Tahoma size=2><FONT color=#0000ff>
<H1><FONT face="Arial Greek" color=#c0c0c0 size=2><SPAN lang=EN-GB>Disclaimer</SPAN></FONT></H1>
<P class=MsoNormal style="MARGIN: 5pt 0cm; mso-layout-grid-align: none"><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US">The information in this e-mail and any attachments is confidential. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are </SPAN><SPAN lang=EN-GB style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US">the</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US"> intended recipient or his/her representative you are not authorized to, and must not, read, copy, distribute, use or retain this message or any part of it. E-mail transmission cannot be</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US"> </SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US">guaranteed to be secure or error-free as information could be</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US"> </SPAN><SPAN lang=EN-US style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US">intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.</SPAN><SPAN lang=EN-GB style="FONT-SIZE: 8pt; COLOR: #999999; FONT-FAMILY: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-US"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P></FONT></FONT></HTML>