[Asterisk-bugs] [Asterisk 0010075]: MS SQL 2005 escape character problem

[noreply at bugs.digium.com]

The following issue requires your FEEDBACK. 
====================================================================== 
http://bugs.digium.com/view.php?id=10075 
====================================================================== 
Reported By:                apsaras
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   10075
Category:                   Core/Configuration
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.5 
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        No 
Request Review:              
====================================================================== 
Date Submitted:             06-27-2007 13:08 CDT
Last Modified:              07-06-2007 00:31 CDT
====================================================================== 
Summary:                    MS SQL 2005 escape character problem
Description: 
I am using Asterisk 1.4.5 with Realtime, unixODBC, freeTDS and MS SQL 2005.
I had some problems getting extensions to work from Database. After a trace
on SQL queries I found the problem. When the extension query is executed is
using \ as escape character at the exten column. Select * From extensions
Where exten like '\_%' .... 

SQL 2005 does not have a default escape character so you might do 
... like '[_]%' ...
 or
... like '\_%' ESCAPE '\'

Is that a freeTDS problem or Asterisk MS SQL implementation problem? 
====================================================================== 

---------------------------------------------------------------------- 
 Corydon76 - 07-06-07 00:31  
---------------------------------------------------------------------- 
apsaras:  I need you to test this patch, to ensure that it works for you. 
Please report back on your testing results. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
07-06-07 00:31  Corydon76      Note Added: 0066577                          
07-06-07 00:31  Corydon76      Status                   assigned => feedback
======================================================================