[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/lib/adodb/drivers/ -> adodb-mssql_n.inc.php (summary)

MSSQL Driver with auto-prepended "N" for correct unicode storage of SQL literal strings. Intended to be used with MSSQL drivers that are sending UCS-2 data to MSSQL (FreeTDS and ODBTP) in order to get true cross-db compatibility from the application point of view.

File Size: 249 lines (10 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:: (1 method):
  __construct()


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 orginal 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

Class: ADORecordset_mssql_n  - X-Ref

__construct($id,$mode=false)   X-Ref
No description



Generated: Thu Aug 11 10:00:09 2016 Cross-referenced by PHPXref 0.7.1