Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
  • Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.

Differences Between: [Versions 310 and 402] [Versions 311 and 402] [Versions 39 and 402]

MSSQL Driver with auto-prepended "N" for correct unicode storage of SQL literal strings.

Copyright: 2000-2013 John Lim
Copyright: 2014 Damien Regad, Mark Newnham and the ADOdb community
License: BSD-3-Clause
License: LGPL-2.1-or-later
File Size: 226 lines (8 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 2 classes

ADODB_mssql_n:: (2 methods):
  _query()
  _appendN()

ADORecordset_mssql_n:: (0 methods):


Class: ADODB_mssql_n  - X-Ref

_query($sql,$inputarr=false)   X-Ref
No description

_appendN($inboundData)   X-Ref
This function will intercept all the literals used in the SQL, prepending the "N" char to them
in order to allow mssql to store properly data sent in the correct UCS-2 encoding (by freeTDS
and ODBTP) keeping SQL compatibility at ADOdb level (instead of hacking every project to add
the "N" notation when working against MSSQL.

The original note indicated that this hack should only be used if ALL the char-based columns
in your DB are of type nchar, nvarchar and ntext, but testing seems to indicate that SQL server
doesn't seem to care if the statement is used against char etc fields.

param: mixed $inboundData Either a string containing an SQL statement
return: mixed