|
|
|
Mr 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
|
|
|
|
|
SSCommitted
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...
|
|
|
|
|
SSCrazy
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.
|
|
|
|
|
Ten 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
|
|
|
|
|
SSC-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. 
|
|
|
|
|
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?
|
|
|
|
|
SSCrazy
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'?"
|
|
|
|
|
SSCommitted
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...
|
|
|
|
|
SSC 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.
|
|
|
|
|
Right 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.
|
|
|
|
