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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-28 : 14:16:01
|
| Amol writes "Why length of TEXT datatype in MS-ACCESS is restricted to 255? Also why ORACLE is restricting its varchar2's length to 4000?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-28 : 15:23:45
|
| The MS Access "text" datatype is equivalent to varchar, and it's always been limited to 255 characters. The "memo" type in Access is equivalent to SQL Server's text data type, which allows for up to 2GB worth of text.Oracle's varchar2 datatype is limited to 4000 bytes, if you need to store more use LONG data columns. |
 |
|
|
|
|
|
MS ACCESS - Text Datatype Length