<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 VM
»
Access
21 posts, Page 2 of 3
««
1
2
3
»»
Access
Rate Topic
Display Mode
Topic Options
Author
Message
Mighty
Mighty
Posted Thursday, June 25, 2009 7:37 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 2,722,
Visits: 987
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
OCTom
OCTom
Posted Thursday, June 25, 2009 8:45 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:56 PM
Points: 2,017,
Visits: 2,850
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
Cliff Jones
Cliff Jones
Posted Thursday, June 25, 2009 8:46 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 3,399,
Visits: 3,408
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
knechod
knechod
Posted Thursday, June 25, 2009 11:05 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, April 18, 2013 6:47 AM
Points: 159,
Visits: 256
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
JF1081
JF1081
Posted Thursday, June 25, 2009 11:14 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, December 07, 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
SMGarner
SMGarner
Posted Thursday, June 25, 2009 12:45 PM
SSChasing 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
Mark Dalley
Mark Dalley
Posted Friday, June 26, 2009 4:52 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:57 AM
Points: 39,
Visits: 788
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
renat ka
renat ka
Posted Tuesday, September 15, 2009 3:54 AM
SSC 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
Bhavesh_Patel
Bhavesh_Patel
Posted Friday, December 11, 2009 3:53 AM
SSChasing 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
kalyani.k478
kalyani.k478
Posted Friday, November 02, 2012 3:54 AM
SSChasing 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 »
21 posts, Page 2 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.
