InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:33:45 GMT20http://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxeasy :)Fri, 02 Nov 2012 03:45:19 GMTkalyani.k478http://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxeasy points for taking. :-DFri, 11 Dec 2009 04:06:41 GMTBhavesh_Patelhttp://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspx[b]O[/b] is Oracle, which is commonly referred to as O-word on this site, and you just made me spell the O-word.Thu, 18 Jun 2009 12:55:27 GMTOleg Netchaevhttp://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxNo, 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, "[b]O[/b] documentation" means [b]Official[/b] documentation?Thu, 18 Jun 2009 12:42:30 GMTJF1081http://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxI don't quite understand the question but according to the [b]O[/b] documentation "[i]VARCHAR2 type is used to store character string values. The VARCHAR type should not be used.[/i]" They say it is "[i]reserved for future use[/i]", but the reality is that it has been in existence for a very long time with the same old "[i]should not be used[/i]" warning. I don't think that I said anything wrong, and I am sorry if my post offended you.OlegThu, 18 Jun 2009 12:04:40 GMTOleg Netchaevhttp://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspx[quote][b]Oleg (6/18/2009)[/b][hr]infamous varchar2 in the [b]O[/b] universe[/quote]What?Thu, 18 Jun 2009 11:49:34 GMTJF1081http://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspx[quote][b]hodgy (6/18/2009)[/b][hr]i hate to be a pedant, but the var in varchar and nvarchar stands for varying:[url=http://msdn.microsoft.com/en-us/library/ms176089.aspx]http://msdn.microsoft.com/en-us/library/ms176089.aspx[/url][/quote]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 [b]N[/b]ational [b]Char[/b]acter [b]Var[/b]ying even though the order of the words does not really match. This mismatch is still much better than infamous varchar2 in the [b]O[/b] 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:OlegThu, 18 Jun 2009 08:47:33 GMTOleg Netchaevhttp://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxHow come 10 % from 556 answered i.e. 55 people think Varchar and nvarchar has fixed value? var stands for varying.Thu, 18 Jun 2009 08:11:31 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxi hate to be a pedant, but the var in varchar and nvarchar stands for varying:[url=http://msdn.microsoft.com/en-us/library/ms176089.aspx]http://msdn.microsoft.com/en-us/library/ms176089.aspx[/url]Thu, 18 Jun 2009 03:21:20 GMThodgyhttp://www.sqlservercentral.com/Forums/Topic737154-1495-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Data+Types/66397/">Data types</A>[/B]Wed, 17 Jun 2009 22:52:25 GMTVM-723206