<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 Carlo Romagnano
»
CASTing
21 posts, Page 1 of 3
1
2
3
»
»»
CASTing
Rate Topic
Display Mode
Topic Options
Author
Message
Carlo Romagnano
Carlo Romagnano
Posted Monday, May 26, 2008 9:37 PM
SSCommitted
Group: General Forum Members
Last Login: Today @ 1:51 AM
Points: 1,971,
Visits: 1,821
Comments posted to this topic are about the item
CASTing
Post #506647
Ramkumar.K
Ramkumar.K
Posted Tuesday, May 27, 2008 12:03 AM
Old Hand
Group: General Forum Members
Last Login: Tuesday, April 03, 2012 3:37 AM
Points: 369,
Visits: 161
Hi All..
declare @c varchar(8000)
set @c = N'hello'
In the above statement there is the "N" mentioned in the beginning of the string.. what does it mean exactly???
Is it indirectly enforcing the casting of varchar into Nvarchar????
Can any one explain??
Thanks in advance..
Ramkumar . K
Senior Developer
######################
No Surrender
...
No Give Up
....
######################
Post #506680
HanShi
HanShi
Posted Tuesday, May 27, 2008 12:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 3:16 AM
Points: 1,117,
Visits: 1,149
Hi,
You can find this information about the N-prefix in the BOL:
Unicode string constants that appear in code executed on the server, such as in stored procedures and triggers, must be preceded by the capital letter N. This is true even if the column being referenced is already defined as Unicode. Without the N prefix, the string is converted to the default code page of the database. This may not recognize certain characters.
Hans
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #506709
Stef315
Stef315
Posted Tuesday, May 27, 2008 1:00 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, March 16, 2011 1:03 PM
Points: 582,
Visits: 14
Where does it say anything about 4000?
Post #506711
Stupeo
Stupeo
Posted Tuesday, May 27, 2008 1:12 AM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:07 AM
Points: 890,
Visits: 774
The answer says it's cast as nvarchar(4000) initially, but i too dont see how?
Am i missing something, or is there a typo?
Matt
Post #506714
HanShi
HanShi
Posted Tuesday, May 27, 2008 1:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 3:16 AM
Points: 1,117,
Visits: 1,149
Because of the N-prefix the value is cast to NVarChar. The NVarChar(MAX) can contain a maximum of 4000.
BOL:
nvarchar [ ( n | max ) ]
Variable-length Unicode character data. n can be a value from 1 through
4,000
. max indicates that the maximum storage size is 2^31-1 bytes. The storage size, in bytes, is two times the number of characters entered + 2 bytes. The data entered can be 0 characters in length. The SQL-2003 synonyms for nvarchar are national char varying and national character varying.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #506718
Stupeo
Stupeo
Posted Tuesday, May 27, 2008 2:08 AM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:07 AM
Points: 890,
Visits: 774
Thankyou Hanshi.
Ive always wondered what the N was for. Thanks.
Matt.
Post #506738
Craig@Work
Craig@Work
Posted Tuesday, May 27, 2008 2:29 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, January 29, 2013 4:08 AM
Points: 1,140,
Visits: 306
Very good question :)
Tests number of areas of knowledge .. what something logically represents vs. what is physically represents
Post #506750
Simon Facer
Simon Facer
Posted Tuesday, May 27, 2008 6:07 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:30 AM
Points: 1,566,
Visits: 600
Just to clarify HanShi's posting - NVARCHAR(MAX) is
not
limited to 4000 characters. The maximum length of VARCHAR(MAX) is 2^31 -1 (2,147,483,647) characters.
Post #506849
Michael.Beeby
Michael.Beeby
Posted Tuesday, May 27, 2008 8:48 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 4:14 AM
Points: 198,
Visits: 588
Uses per character 16 bits rather than 8.
Post #506970
« Prev Topic
|
Next Topic »
21 posts, Page 1 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.
