Data types

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » Data types

Data types

Rate Topic

Display Mode

Topic Options

Author

Message

VM-723206

Posted Wednesday, June 17, 2009 10:52 PM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263

Comments posted to this topic are about the item Data types

Post #737154

hodgy

Posted Thursday, June 18, 2009 3:21 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:55 AM
Points: 1,865, Visits: 556

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

SanjayAttray

Posted Thursday, June 18, 2009 8:11 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

Oleg Netchaev

Posted Thursday, June 18, 2009 8:47 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:39 PM
Points: 1,662, Visits: 1,708

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 Hehe

Oleg

Post #737626

JF1081

Posted Thursday, June 18, 2009 11:49 AM

SSC-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

Oleg Netchaev

Posted Thursday, June 18, 2009 12:04 PM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:39 PM
Points: 1,662, Visits: 1,708

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

JF1081

Posted Thursday, June 18, 2009 12:42 PM

SSC-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