[CF-Database] (no subject)

["Tim Blair" <tblair@rawnet.com>]

Afternoon all,

Right, I'm new to all this SQL Server / T-SQL malarky (MySQL man
here...)  Inherited code help here we come!

I have a table which contains a number of fields declared as NVARCHARs.
When performing an insert, the actual data passed has an N at the
beginning, e.g. ..., N'text',...  First question: why's that then?

Secondly, some inserts are creating empty string fields as just N' (an N
followed by one single quote).  Running on a local copy of SQL Server
(SQL Server 2000 v8.00.760) this works fine, but on the live server (SQL
Server 2000 v8.00.818) it barfs on this implying that it's treating the
single quote as an opening string mark.

Why the difference between these two?  I'm assuming there's a setting
someone I need to change?

Thanks,

Tim.

--
-------------------------------------------------------
Badpen Tech - CF and web-tech: http://tech.badpen.com/
-------------------------------------------------------
    RAWNET LTD - independent digital media agency
    "We are big, we are funny and we are clever!"
     New site launched at http://www.rawnet.com/
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------