Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Character Data Types
Message
From
13/02/2002 16:14:51
 
 
To
13/02/2002 16:07:54
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00619696
Message ID:
00619699
Views:
12
>> If this is the case can someone tell me why char is the default?

I can't.

>> What do y'all like to use a preference for basic text?

nvarchar()

When dealing with SQL Server 6.5, it was perferable to use a fixed, non-nullable datatype, like CHAR. I don't remember the exact reason but it had to do with the way that the row was organized on the page.

For SQL Server 7.0 and later, those issues were addressed. Most recommendations that I have seen list using varchar() over char().

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform