Varchar vs char - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Varchar vs char

Message

03/11/1999 18:06:34

Michael Levy
Cincinnati, Ohio, États-Unis

03/11/1999 10:45:01

Ken Matson
GCom2 Solutions
Aston, Pennsylvanie, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Conception bases de données

Titre:

Re: Varchar vs char

Divers

Thread ID:

00285417

Message ID:

00286549

Vues:

Ken,

As you found out, SQL Server cannot create an index on an expression.

Your best bet would probably be the varchar witht the hope that not every job title would be 64 bytes long.

-Mike

Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com

Répondre

Fil

Voir

Click here to load this message in the networking platform