[Asterisk-bugs] [Asterisk 0010075]: MS SQL 2005 escape character problem
noreply at bugs.digium.com
noreply at bugs.digium.com
Fri Jul 6 07:56:07 CDT 2007
A NOTE has been added to this issue.
======================================================================
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 07:56 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?
======================================================================
----------------------------------------------------------------------
apsaras - 07-06-07 07:56
----------------------------------------------------------------------
Yes it is works fine. Thank you.
Issue History
Date Modified Username Field Change
======================================================================
07-06-07 07:56 apsaras Note Added: 0066581
======================================================================
More information about the Asterisk-bugs
mailing list