Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Varchar vs. char
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00690420
Message ID:
00690451
Vues:
13
>While I agree with you, the overhead is not enough to worry about IMO. Unless the data is fixed length, I always use nvarchar for strings.

I am pulling from BOL:

Use char when the data values in a column are expected to be consistently close to the same size.

Use varchar when the data values in a column are expected to vary considerably in size.

If is your experience that there is not much of a performance difference? Also, why nvarchar? Is Unicode that popular, or due to the fact the SET ANSI_PADDING is always ON?
Chris McCandless
Red Sky Software
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform