General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Varchar versus Text Data Type in SQL Server
Is there an advantage to using Varchar over Text in SQL*Server? Let's say I have a situation where the expected limits are under 4000 bytes, so that I might be willing to force a truncation in an Edit region, if there were benefits. Is there a (performance or feature-based) reason to avoid Text? Given my VFP heritage, my inclination is to think of Text as like Memo, and use it for anything long.
TIA,
-- Randy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only