Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Greg Goodge » VARCHAR datatype
Add to briefcase
38 posts, Page 4 of 4
«««1234

VARCHAR datatype Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ziangij
Posted Monday, July 19, 2010 11:36 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,529, Visits: 359
thanks, this explains everything...


DECLARE @Testvar VARCHAR;
SET @Testvar = 'Red';
print @Testvar;
Post #955295
Carla Wilson-484785
Posted Tuesday, July 20, 2010 8:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:15 AM
Points: 1,352, Visits: 1,738
Excellent question! I don't think it's so much about relying on a default (bad practice) so much as forgetting to specify the length, which may not result in a syntax error, and may return results which are incorrect.
Thanks for the reality check.
Post #955624
KevinC.
Posted Tuesday, July 20, 2010 9:07 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 12:55 AM
Points: 771, Visits: 504
Excellent question. Defaults are always something to keep in mind and to avoid relying on, as they may change.
Post #955663
Sqlchicken
Posted Tuesday, July 20, 2010 10:34 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:13 AM
Points: 134, Visits: 617
Good question, got it wrong. Didn't know about default length being set to 1 if not declared. Nice job!

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Post #955746
L' Eomot Inversé
Posted Monday, July 26, 2010 5:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:35 PM
Points: 7,102, Visits: 7,166
Good question. I got it wrong, because I didn't notice that the length wasn't specified. That will teach me not to skim read code when working out what it does (something I've often told others they must not do, but am still stupid enough to do it myself).

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #959149
dbuendiab
Posted Wednesday, July 28, 2010 5:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:41 AM
Points: 77, Visits: 218
Good question! I was shocked to see the four rows when I tried the query!

Leaving aside the issue of the COLLATION, I opted for the one row answer, because the first that came to mind was the default value of varchar in the CONVERT function, which is 30.

select convert (varchar, '123456789012345678901234567890123456789012345678901234567890 ')
Post #959956
hayk-736382
Posted Tuesday, August 17, 2010 1:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 31, 2013 5:36 PM
Points: 10, Visits: 10
Because all colors are in proper case one can be led to believe that case sensitivity is a factor. To avoide this confusion it would be better to have all colors in lower or upper case.
Post #970168
zymos
Posted Wednesday, March 07, 2012 3:15 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:43 AM
Points: 469, Visits: 193
Nice and interesting question.
Post #1263324
« Prev Topic | Next Topic »

Add to briefcase
38 posts, Page 4 of 4
«««1234

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.