[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [CF-Database] (no subject)
Indeed. Apologies.
The problem is more than likely due to Compatibility Level. To check SQL
Servers compatibility you can open up Query Analyser and type the following:
exec sp_dbcmptlevel [yourdbname] - It will come back with your level. To
support Unicode it should say : "The current compatibility level is 80."
If it says The current compatibility level is 70. you will need set it to 80
by type the following in QA and executing it: EXEC sp_dbcmptlevel
[yourdbname], 80. Or you can do all of this via each Databases Properties
via Enterprise Manager.
HTH
N
-----Original Message-----
From: database-bounces@list.cfdeveloper.co.uk
[mailto:database-bounces@list.cfdeveloper.co.uk] On Behalf Of Russ Michaels
(Snake)
Sent: 08 February 2005 22:57
To: 'database programming'
Subject: RE: [CF-Database] (no subject)
No don't do it offline, this is useful stuff everyone should know.
> -----Original Message-----
> From: database-bounces@list.cfdeveloper.co.uk
> [mailto:database-bounces@list.cfdeveloper.co.uk] On Behalf Of
> Robertson-Ravo, Neil (RX)
> Sent: 08 February 2005 16:34
> To: database programming
> Subject: RE: [CF-Database] (no subject)
>
>
> N' dictates it as a Unicode Native Format. Using native
> format for noncharacter data saves time, preventing
> unnecessary conversion of data types to and from character
> format. Using Unicode character format for all character data
> prevents loss of any extended characters when bulk loading
> data between servers using different code pages. However, a
> data file in Unicode native format can be read only by the
> bcp utility and the BULK INSERT statement. i.e. if you enter
> stuff in Chinese - it stays in Chinese!
>
> Your local copy is not fully patched - you should sort that
> out pronto ;-)
>
> Check out the Database Compatibility level on the other
> server. It will have to be 8.0 to use Unicode.
>
> It may also be related to a DBCC setting or the servers collation.
>
> Let me know if you need more info offline or via MSN
>
> N
>
>
>
>
>
>
> -----Original Message-----
> From: database-bounces@list.cfdeveloper.co.uk
> [mailto:database-bounces@list.cfdeveloper.co.uk] On Behalf Of
> Tim Blair
> Sent: 08 February 2005 16:17
> To: database@list.cfdeveloper.co.uk
> Subject: [CF-Database] (no subject)
>
>
>
> 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.
> -------------------------------------------------------
> --
> For details on ALL mailing lists and for joining or leaving
> lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors and Supporters:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Lists hosted by www.Gradwell.com -<
> >- supporters:- www.apycom.com : www.proworkflow.com -<
> >- CFdeveloper is run and managed by Russ Michaels, feel free to
> >volunteer
> your help -<
> This e-mail is from Reed Exhibitions (Oriel House, 26 The
> Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a
> division of Reed Business, Registered in England, Number
> 678540. It contains information which is confidential and
> may also be privileged. It is for the exclusive use of the
> intended recipient(s). If you are not the intended
> recipient(s) please note that any form of distribution,
> copying or use of this communication or the information in it
> is strictly prohibited and may be unlawful. If you have
> received this communication in error please return it to the
> sender or call our switchboard on +44 (0) 20 89107910. The
> opinions expressed within this communication are not
> necessarily those expressed by Reed Exhibitions.
> Visit our website at http://www.reedexpo.com
> --
> For details on ALL mailing lists and for joining or leaving
> lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors and Supporters:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Lists hosted by www.Gradwell.com -<
> >- supporters:- www.apycom.com : www.proworkflow.com -<
> >- CFdeveloper is run and managed by Russ Michaels, feel free to
> >volunteer your help -<
>
--
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors and Supporters:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- supporters:- www.apycom.com : www.proworkflow.com -<
>- CFdeveloper is run and managed by Russ Michaels, feel free to volunteer
your help -<
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com