<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Rahul Kr. Ghosh
»
Printing Lengths
28 posts, Page 3 of 3
««
«
1
2
3
Printing Lengths
Rate Topic
Display Mode
Topic Options
Author
Message
Rahul The Dba
Rahul The Dba
Posted Tuesday, December 14, 2010 1:03 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 3:52 AM
Points: 127,
Visits: 123
Hardy21 (12/14/2010)
Nice question. Learn something new today...
thankss
Rahul
Post #1034228
Carlo Romagnano
Carlo Romagnano
Posted Tuesday, December 14, 2010 4:10 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 1,996,
Visits: 1,864
This is an old kind of COBOL bug:
using bad datatype to hold integer:
01 IDX PIC 9.
PERFORM LBL VARYING IDX BY 1 UNTIL IDX > 10.
Endless loop
Post #1034277
michael.kaufmann
michael.kaufmann
Posted Friday, December 17, 2010 8:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 28, 2013 1:34 AM
Points: 1,263,
Visits: 1,080
Thanks for the question, Rahul.
But personally I find the explanation somewhat confusing, specifically the last paragraph where it reads:
It is '*' because when we convert character or binary expressions to an expression of a different data type, data can be truncated, only partially displayed, or an error is returned because the result is too short to display. * means the result length too short to display
In regards to the default length when n is undefined, it doesn't make a difference whether you use CAST or CONVERT.
@length1 prints 1 because no conversion is carried out (varchar = varchar).
@length2 prints * because the result (30, due to the conversion from varchar to char) actually is too
long
to fit into a column implicitely set to varchar(1) = by not specifying the length in the variable declarartion.
Regards,
Michael
Post #1036573
Paul White
Paul White
Posted Saturday, December 18, 2010 6:34 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 10,990,
Visits: 10,578
I took a stab at 1,30. So it was 1,*. Ha, very good. I'll have forgotten this again in half an hour, and I still won't care
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1036876
UMG Developer
UMG Developer
Posted Saturday, December 18, 2010 3:00 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 2,163,
Visits: 2,151
SQLkiwi (12/18/2010)
I took a stab at 1,30. So it was 1,*. Ha, very good. I'll have forgotten this again in half an hour, and I still won't care
Will you have forgotten it again because you always specify the length and this isn't an issue? (Unless of course you are working on code written by somebody that doesn't.)
Post #1036925
Paul White
Paul White
Posted Saturday, December 18, 2010 7:38 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 10,990,
Visits: 10,578
UMG Developer (12/18/2010)
Will you have forgotten it again because you always specify the length and this isn't an issue? (Unless of course you are working on code written by somebody that doesn't.)
Yes. If I do have to work on code written by someone that thought it was clever to omit lengths, I always have to look it up to be sure.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1036941
hakan.winther
hakan.winther
Posted Thursday, August 11, 2011 12:55 AM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 06, 2013 5:31 AM
Points: 2,226,
Visits: 438
Thanks for the question! Learned something today. I knew about the default length for char/varchar, but not the convert issue. An important sample to show why you shouldn't omit default values or on mandatory statements.
/Håkan Winther
MCITP:Database Developer 2008
Post #1158213
zymos
zymos
Posted Monday, February 27, 2012 10:14 AM
SSC-Addicted
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 8:52 AM
Points: 469,
Visits: 199
Thanks for the question on the data types.
Post #1258385
« Prev Topic
|
Next Topic »
28 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
