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


12»»

Access Expand / Collapse
Author
Message
Posted Wednesday, June 24, 2009 9:16 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 27, 2010 9:43 AM
Points: 565, Visits: 177
Comments posted to this topic are about the item Access
Post #741510
Posted Thursday, June 25, 2009 6:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:48 AM
Points: 1,547, Visits: 324
Maybe it's just me, but I read the question differently, looking for the SQL Server data type to match the MS Access data type. Might be that my English is not good enough...
Post #741732
Posted Thursday, June 25, 2009 6:02 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:50 AM
Points: 2,842, Visits: 698
Michael Kipp (6/25/2009)
Maybe it's just me, but I read the question differently, looking for the SQL Server data type to match the MS Access data type. Might be that my English is not good enough...


It's not just you... I read it the same way and as a result answered nvarchar.



Post #741735
Posted Thursday, June 25, 2009 6:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 18, 2010 11:59 AM
Points: 1,398, Visits: 326
http://office.microsoft.com/en-us/access/HA012314471033.aspx
Post #741742
Posted Thursday, June 25, 2009 6:58 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 445, Visits: 1,779
Gawd, I feel awful for actually knowing the answer.


Post #741771
Posted Thursday, June 25, 2009 7:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 12, 2010 9:35 AM
Points: 936, Visits: 209
Who cares?? What does Access have to do with REAL databases?
Post #741774
Posted Thursday, June 25, 2009 7:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:14 AM
Points: 2,484, Visits: 385
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'?"
Post #741790
Posted Thursday, June 25, 2009 7:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:48 AM
Points: 1,547, Visits: 324
Irish Flyer (6/25/2009)
Who cares?? What does Access have to do with REAL databases?

Not too much, so in that respect the question of matching a MS Access data type to a SQL Server data type makes even more sense, since that knowledge is needed when migrating those datatbases to real ones...
Post #741805
Posted Thursday, June 25, 2009 7:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:37 AM
Points: 244, Visits: 630
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.
Post #741807
Posted Thursday, June 25, 2009 7:33 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 5:44 AM
Points: 735, Visits: 271
I did even worse, I went into Access, opened the design of a table, saw that my character type fields are formatted "text" so opted for "text."

I have to admit though, it was worth it. I now have a much better understanding of the difference between text and varchar in SQL and memo and text in Access.
Post #741812
« Prev Topic | Next Topic »

12»»

Permissions Expand / Collapse