Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
I'm going to have a sulk |
Wed, Jan 23 2008 11:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | and probably stamp my feet and hold my breath until I turn blue!
Q. When does an empty string -= NULL A. ALTER TABLE "Billing" ALTER COLUMN "_Company" AS VARCHAR(60) COLLATE "ANSI" DESCRIPTION '' I think that's cheating <vbg> Roy Lambert |
Wed, Jan 23 2008 3:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< and probably stamp my feet and hold my breath until I turn blue! Q. When does an empty string -= NULL A. ALTER TABLE "Billing" ALTER COLUMN "_Company" AS VARCHAR(60) COLLATE "ANSI" DESCRIPTION '' I think that's cheating <vbg> >> It's a whole different issue. The catalog tables population simply treats a blank description as "not being populated" since there is no concept of NULLs for catalog metadata like descriptions. It's either there or not. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jan 24 2008 4:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
<<It's either there or not.>> Now you come to mention it - that's my attitude to VARCHAR's and CHARs in general - thanks for the straight line. Roy Lambert |
Thu, Jan 24 2008 2:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Now you come to mention it - that's my attitude to VARCHAR's and CHARs in general - thanks for the straight line. >> Yes, and that's exactly how they work. A Null is simply a there/not there flag. The fact that you think an empty string "there" should the same as "not there" is an argument that you can take up with the ANSI/ISO SQL standards body. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jan 25 2008 3:45 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Yes, and that's exactly how they work. A Null is simply a there/not there >flag. The fact that you think an empty string "there" should the same as >"not there" is an argument that you can take up with the ANSI/ISO SQL >standards body. Don't worry if I ever get them round the back of the bike shed I certainly going to put my viewpoint forcibly. Roy Lambert |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |