Groups > comp.databases.ms-sqlserver > #1406

Re: How to determine true contents of not null columns that display as empty

X-Received	by 10.224.213.197 with SMTP id gx5mr23210603qab.8.1362677364591; Thu, 07 Mar 2013 09:29:24 -0800 (PST)
X-Received	by 10.49.75.195 with SMTP id e3mr3502186qew.24.1362677364328; Thu, 07 Mar 2013 09:29:24 -0800 (PST)
Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder2.hal-mli.net!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!t2no9837377qal.0!news-out.google.com!p7ni382qai.0!nntp.google.com!dd2no8043084qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Thu, 7 Mar 2013 09:29:24 -0800 (PST)
In-Reply-To	<60db4087-d8ae-4cbf-9a40-531637ccef0e@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=194.83.173.135; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP
NNTP-Posting-Host	194.83.173.135
References	<60db4087-d8ae-4cbf-9a40-531637ccef0e@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<58d91000-cfd5-40c8-8cd4-bbfb34a2b944@googlegroups.com> (permalink)
Subject	Re: How to determine true contents of not null columns that display as empty
From	rja.carnegie@gmail.com
Injection-Date	Thu, 07 Mar 2013 17:29:24 +0000
Content-Type	text/plain; charset=ISO-8859-1
Lines	10
Xref	csiph.com comp.databases.ms-sqlserver:1406

Show key headers only | View raw

A varchar or nvarchar string with length zero isn't NULL, but
it doesn't have an ASCII code, since it doesn't have a first 
character.

Consider "UPDATE theTable SET acceptor = '' "

My SQL Server documentation says that ASCII() "Returns the ASCII 
code value of the leftmost character of a character expression
(and by the way, on nvarchar you do want the UNICODE function 
instead), but doesn't mention this case - no leftmost character, 
so, ASCII returns NULL.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to determine true contents of not null columns that display as empty Mark D Powell <Mark.Powell2@hp.com> - 2013-03-07 09:16 -0800
  Re: How to determine true contents of not null columns that display as empty rja.carnegie@gmail.com - 2013-03-07 09:29 -0800
  Re: How to determine true contents of not null columns that display as empty Erland Sommarskog <esquel@sommarskog.se> - 2013-03-07 22:55 +0100
    Re: How to determine true contents of not null columns that display as empty rja.carnegie@gmail.com - 2013-03-07 15:06 -0800
  Re: How to determine true contents of not null columns that display as empty Mark D Powell <Mark.Powell2@hp.com> - 2013-03-14 10:56 -0700

csiph-web