Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data types Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 10:52 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item Data types
Post #737154
Posted Thursday, June 18, 2009 3:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, March 03, 2014 8:29 AM
Points: 1,865, Visits: 584
i hate to be a pedant, but the var in varchar and nvarchar stands for varying:

http://msdn.microsoft.com/en-us/library/ms176089.aspx


Life: it twists and turns like a twisty turny thing
Post #737303
Posted Thursday, June 18, 2009 8:11 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:58 AM
Points: 3,924, Visits: 1,588
How come 10 % from 556 answered i.e. 55 people think Varchar and nvarchar has fixed value? var stands for varying.

SQL DBA.
Post #737578
Posted Thursday, June 18, 2009 8:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:53 PM
Points: 1,676, Visits: 1,744
hodgy (6/18/2009)
i hate to be a pedant, but the var in varchar and nvarchar stands for varying:

http://msdn.microsoft.com/en-us/library/ms176089.aspx


As a matter of fact there was a question of a day not too long ago asking why nvarchar is named as it is. The answer to the question was nvarchar stands for National Character Varying even though the order of the words does not really match. This mismatch is still much better than infamous varchar2 in the O universe where they originally had a type named varchar which implementation was probably so messed up that the O-people came up with a "brilliant" idea to develop another type and creatively name it varchar2 while leaving outdated varchar still available

Oleg
Post #737626
Posted Thursday, June 18, 2009 11:49 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:13 AM
Points: 436, Visits: 322
Oleg (6/18/2009)

infamous varchar2 in the O universe

What?
Post #737803
Posted Thursday, June 18, 2009 12:04 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:53 PM
Points: 1,676, Visits: 1,744
I don't quite understand the question but according to the O documentation "VARCHAR2 type is used to store character string values. The VARCHAR type should not be used." They say it is "reserved for future use", but the reality is that it has been in existence for a very long time with the same old "should not be used" warning. I don't think that I said anything wrong, and I am sorry if my post offended you.

Oleg
Post #737808
Posted Thursday, June 18, 2009 12:42 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:13 AM
Points: 436, Visits: 322
No, let me apologize, you did not offend me. I just do not know what the "O universe" is.
I suppose I should have written, "What is the ""O universe""?"

But if I had to guess, "O documentation" means Official documentation?
Post #737834
Posted Thursday, June 18, 2009 12:55 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:53 PM
Points: 1,676, Visits: 1,744
O is Oracle, which is commonly referred to as O-word on this site, and you just made me spell the O-word.
Post #737842
Posted Friday, December 11, 2009 4:06 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
easy points for taking.



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #832807
Posted Friday, November 02, 2012 3:45 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616, Visits: 97
easy :)
Post #1380227
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse