The Artima Developer Community
Sponsored Link

.NET Buzz Forum
Befuddled Tech - Sybase strings and nulls

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Steve Hebert

Posts: 218
Nickname: sdhebert
Registered: Apr, 2005

Steve Hebert is a .NET developer who has created the .Math compiler library.
Befuddled Tech - Sybase strings and nulls Posted: Jun 20, 2006 11:23 AM
Reply to this message Reply

This post originated from an RSS feed registered with .NET Buzz by Steve Hebert.
Original Post: Befuddled Tech - Sybase strings and nulls
Feed Title: Steve Hebert's Development Blog
Feed URL: /error.htm?aspxerrorpath=/blogs/steve.hebert/rss.aspx
Feed Description: .Steve's .Blog - Including .Net, SQL Server, .Math and everything in between
Latest .NET Buzz Posts
Latest .NET Buzz Posts by Steve Hebert
Latest Posts From Steve Hebert's Development Blog

Advertisement
We ran into a problem with our Sybase servers and how they store strings.  It turns out that when you store an empty string,  Sybase always returns a single space.  Using the following insert statement (quoted string with no space).

insert into customer (lastname) values ('')

The result is lastname == '{space}'

I didn't think any commercial database still implemented it this way. 

Note to Sybase - empty string and null are two distinctly different values.







Read: Befuddled Tech - Sybase strings and nulls

Topic: [Lokal] Der Karnevalsumzug der Fans aus Trinidad & Tobago Previous Topic   Next Topic Topic: Commerce Server 2007 ships

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use