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 ««123»»

Access Expand / Collapse
Author
Message
Posted Thursday, June 25, 2009 7:37 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: Today @ 6:48 AM
Points: 3,201, Visits: 1,239
Andrew Watson (6/25/2009)
I'm with David on this one. The question as written is totally ambiguous, and nvarchar or memo are equally valid answers, depending on how you parse the question.

I agree on this. Anyone who gave one of both answers, should be granted the point. Because the point is what it is all about!
Post #741817
Posted Thursday, June 25, 2009 8:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 2,518, Visits: 3,718
There are two "text" type fields in Access: Text and Memo. That's the way I read it.

But, I thought we were'nt supposed to use the SQL Server TEXT data type anyway.
Post #741869
Posted Thursday, June 25, 2009 8:46 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, July 24, 2014 7:30 AM
Points: 3,871, Visits: 3,621
dmbaker (6/25/2009)
Gawd, I feel awful for actually knowing the answer.


I got this one wrong. I can live with that.
Post #741870
Posted Thursday, June 25, 2009 11:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 12, 2014 6:43 AM
Points: 160, Visits: 266
David Harder (6/25/2009)
I missed this also because I read the question. It says "What is the equivalent of 'text' data type in MS Access?"

Although the majority are getting it "correct" I also read it to mean the other direction. The question should have been worded something like "What is the MS Access equivalent to the SQL data type 'text'?"


I see I'm not the only one to read the question that way! Another vote for points!

Kevin


--
Please upgrade to .sig 2.0
Post #742024
Posted Thursday, June 25, 2009 11:14 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, December 7, 2010 8:13 AM
Points: 436, Visits: 322
I read it and figured it could be answered both ways so I had a 50 - 50 change to get it right. I chose TEXT data type in Access = NVARCHAR data type in SQL
Post #742038
Posted Thursday, June 25, 2009 12:45 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 27, 2010 6:55 AM
Points: 636, Visits: 67
It should be noted that the reference and notes apply to Unicode and Access 4.0.

Additional references:

Equivalent ANSI SQL Data Types
URL; http://msdn.microsoft.com/en-us/library/bb177899.aspx

and

SQL Data Types
http://msdn.microsoft.com/en-us/library/bb208866.aspx

indicate that text in MS Access 2007, Zero to a maximum of 2.14 gigabytes, equivalent to text in SQL.
Post #742118
Posted Friday, June 26, 2009 4:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:51 AM
Points: 41, Visits: 925
knechod (6/25/2009)
David Harder (6/25/2009)
I missed this also because I read the question. It says "What is the equivalent of 'text' data type in MS Access?"

Although the majority are getting it "correct" I also read it to mean the other direction. The question should have been worded something like "What is the MS Access equivalent to the SQL data type 'text'?"


I see I'm not the only one to read the question that way! Another vote for points!

Kevin


Me too. The question contains an ambiguous inner join, I would suggest.

MarkD
Post #742536
Posted Tuesday, September 15, 2009 3:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 15, 2011 8:19 AM
Points: 79, Visits: 28
this question should be rewritten, becuase of the ambigious reading!
Post #788042
Posted Friday, December 11, 2009 3:53 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
I to got wrong



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #832800
Posted Friday, November 2, 2012 3:54 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
confused as Acess has both text n memo data types...Got it right though
Post #1380231
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse