Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bouno
Starting Member
23 Posts |
 Posted - 2003-01-09 : 11:20:27
|
| Hello all, what is the equivalent mssql server datatype varchar to microsoft access? thanks, bn |
|
|
rme8494
Yak Posting Veteran
98 Posts |
Posted - 2003-01-09 : 11:23:00
|
| Memo would probably be the closestRyan EverhartSBC Ameritech |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-09 : 11:30:53
|
| Actually, regular MS Access text data is the equivalent to varchar. |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-01-10 : 05:40:31
|
| Thats right Rob, but the Access Text datatype goes only upto 255 characters, while the varchar goes upto 8000OS |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-10 : 06:20:37
|
| It might also pay to be aware of row size limitations which in SQL Server is aomething like 8064 chars so if you have multiple varchar(8000) or so fields if they are fairly full then you may have problems. I would assume (but don't know) that Access has smaller limits than SQL Server ??===========Paul |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-10 : 06:46:54
|
8060 max row size  ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Varchar Data type