1 | <?php |
---|
2 | |
---|
3 | /// $Id $ |
---|
4 | |
---|
5 | /////////////////////////////////////////////////////////////////////////// |
---|
6 | // // |
---|
7 | // NOTICE OF COPYRIGHT // |
---|
8 | // // |
---|
9 | // ADOdb - Database Abstraction Library for PHP // |
---|
10 | // http://adodb.sourceforge.net/ // |
---|
11 | // // |
---|
12 | // Copyright (C) 2000-2007 John Lim (jlim\@natsoft.com.my) // |
---|
13 | // All rights reserved. // |
---|
14 | // Released under both BSD license and LGPL library license. // |
---|
15 | // Whenever there is any discrepancy between the two licenses, // |
---|
16 | // the BSD license will take precedence // |
---|
17 | // // |
---|
18 | // Moodle - Modular Object-Oriented Dynamic Learning Environment // |
---|
19 | // http://moodle.com // |
---|
20 | // // |
---|
21 | // Copyright (C) 2001-3001 Martin Dougiamas http://dougiamas.com // |
---|
22 | // (C) 2001-3001 Eloy Lafuente (stronk7) http://contiento.com // |
---|
23 | // // |
---|
24 | // This program is free software; you can redistribute it and/or modify // |
---|
25 | // it under the terms of the GNU General Public License as published by // |
---|
26 | // the Free Software Foundation; either version 2 of the License, or // |
---|
27 | // (at your option) any later version. // |
---|
28 | // // |
---|
29 | // This program is distributed in the hope that it will be useful, // |
---|
30 | // but WITHOUT ANY WARRANTY; without even the implied warranty of // |
---|
31 | // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // |
---|
32 | // GNU General Public License for more details: // |
---|
33 | // // |
---|
34 | // http://www.gnu.org/copyleft/gpl.html // |
---|
35 | // // |
---|
36 | /////////////////////////////////////////////////////////////////////////// |
---|
37 | |
---|
38 | /** |
---|
39 | * MSSQL Driver with auto-prepended "N" for correct unicode storage |
---|
40 | * of SQL literal strings. Intended to be used with MSSQL drivers that |
---|
41 | * are sending UCS-2 data to MSSQL (FreeTDS and ODBTP) in order to get |
---|
42 | * true cross-db compatibility from the application point of view. |
---|
43 | */ |
---|
44 | |
---|
45 | // security - hide paths |
---|
46 | if (!defined('ADODB_DIR')) die(); |
---|
47 | |
---|
48 | // one useful constant |
---|
49 | if (!defined('SINGLEQUOTE')) define('SINGLEQUOTE', "'"); |
---|
50 | |
---|
51 | include_once(ADODB_DIR.'/drivers/adodb-mssql.inc.php'); |
---|
52 | |
---|
53 | class ADODB_mssql_n extends ADODB_mssql { |
---|
54 | var $databaseType = "mssql_n"; |
---|
55 | |
---|
56 | function ADODB_mssqlpo() |
---|
57 | { |
---|
58 | ADODB_mssql::ADODB_mssql(); |
---|
59 | } |
---|
60 | |
---|
61 | function _query($sql,$inputarr) |
---|
62 | { |
---|
63 | $sql = $this->_appendN($sql); |
---|
64 | return ADODB_mssql::_query($sql,$inputarr); |
---|
65 | } |
---|
66 | |
---|
67 | /** |
---|
68 | * This function will intercept all the literals used in the SQL, prepending the "N" char to them |
---|
69 | * in order to allow mssql to store properly data sent in the correct UCS-2 encoding (by freeTDS |
---|
70 | * and ODBTP) keeping SQL compatibility at ADOdb level (instead of hacking every project to add |
---|
71 | * the "N" notation when working against MSSQL. |
---|
72 | * |
---|
73 | * Note that this hack only must be used if ALL the char-based columns in your DB are of type nchar, |
---|
74 | * nvarchar and ntext |
---|
75 | */ |
---|
76 | function _appendN($sql) { |
---|
77 | |
---|
78 | $result = $sql; |
---|
79 | |
---|
80 | /// Check we have some single quote in the query. Exit ok. |
---|
81 | if (strpos($sql, SINGLEQUOTE) === false) { |
---|
82 | return $sql; |
---|
83 | } |
---|
84 | |
---|
85 | /// Check we haven't an odd number of single quotes (this can cause problems below |
---|
86 | /// and should be considered one wrong SQL). Exit with debug info. |
---|
87 | if ((substr_count($sql, SINGLEQUOTE) & 1)) { |
---|
88 | if ($this->debug) { |
---|
89 | ADOConnection::outp("{$this->databaseType} internal transformation: not converted. Wrong number of quotes (odd)"); |
---|
90 | } |
---|
91 | return $sql; |
---|
92 | } |
---|
93 | |
---|
94 | /// Check we haven't any backslash + single quote combination. It should mean wrong |
---|
95 | /// backslashes use (bad magic_quotes_sybase?). Exit with debug info. |
---|
96 | $regexp = '/(\\\\' . SINGLEQUOTE . '[^' . SINGLEQUOTE . '])/'; |
---|
97 | if (preg_match($regexp, $sql)) { |
---|
98 | if ($this->debug) { |
---|
99 | ADOConnection::outp("{$this->databaseType} internal transformation: not converted. Found bad use of backslash + single quote"); |
---|
100 | } |
---|
101 | return $sql; |
---|
102 | } |
---|
103 | |
---|
104 | /// Remove pairs of single-quotes |
---|
105 | $pairs = array(); |
---|
106 | $regexp = '/(' . SINGLEQUOTE . SINGLEQUOTE . ')/'; |
---|
107 | preg_match_all($regexp, $result, $list_of_pairs); |
---|
108 | if ($list_of_pairs) { |
---|
109 | foreach (array_unique($list_of_pairs[0]) as $key=>$value) { |
---|
110 | $pairs['<@#@#@PAIR-'.$key.'@#@#@>'] = $value; |
---|
111 | } |
---|
112 | if (!empty($pairs)) { |
---|
113 | $result = str_replace($pairs, array_keys($pairs), $result); |
---|
114 | } |
---|
115 | } |
---|
116 | |
---|
117 | /// Remove the rest of literals present in the query |
---|
118 | $literals = array(); |
---|
119 | $regexp = '/(N?' . SINGLEQUOTE . '.*?' . SINGLEQUOTE . ')/is'; |
---|
120 | preg_match_all($regexp, $result, $list_of_literals); |
---|
121 | if ($list_of_literals) { |
---|
122 | foreach (array_unique($list_of_literals[0]) as $key=>$value) { |
---|
123 | $literals['<#@#@#LITERAL-'.$key.'#@#@#>'] = $value; |
---|
124 | } |
---|
125 | if (!empty($literals)) { |
---|
126 | $result = str_replace($literals, array_keys($literals), $result); |
---|
127 | } |
---|
128 | } |
---|
129 | |
---|
130 | /// Analyse literals to prepend the N char to them if their contents aren't numeric |
---|
131 | if (!empty($literals)) { |
---|
132 | foreach ($literals as $key=>$value) { |
---|
133 | if (!is_numeric(trim($value, SINGLEQUOTE))) { |
---|
134 | /// Non numeric string, prepend our dear N |
---|
135 | $literals[$key] = 'N' . trim($value, 'N'); //Trimming potentially existing previous "N" |
---|
136 | } |
---|
137 | } |
---|
138 | } |
---|
139 | |
---|
140 | /// Re-apply literals to the text |
---|
141 | if (!empty($literals)) { |
---|
142 | $result = str_replace(array_keys($literals), $literals, $result); |
---|
143 | } |
---|
144 | |
---|
145 | /// Re-apply pairs of single-quotes to the text |
---|
146 | if (!empty($pairs)) { |
---|
147 | $result = str_replace(array_keys($pairs), $pairs, $result); |
---|
148 | } |
---|
149 | |
---|
150 | /// Print transformation if debug = on |
---|
151 | if ($result != $sql && $this->debug) { |
---|
152 | ADOConnection::outp("{$this->databaseType} internal transformation:<br>{$sql}<br>to<br>{$result}"); |
---|
153 | } |
---|
154 | |
---|
155 | return $result; |
---|
156 | } |
---|
157 | } |
---|
158 | |
---|
159 | class ADORecordset_mssql_n extends ADORecordset_mssql { |
---|
160 | var $databaseType = "mssql_n"; |
---|
161 | function ADORecordset_mssql_n($id,$mode=false) |
---|
162 | { |
---|
163 | $this->ADORecordset_mssql($id,$mode); |
---|
164 | } |
---|
165 | } |
---|
166 | ?> |
---|