Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IMAGE or TEXT
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Divers
Thread ID:
00949240
Message ID:
00949566
Vues:
10
Hello Simplicio,

As far as I know (I read that somewhere), internally, there are no differences between Text and Image data types in SQL Server.

However, "by-design", I would store text in the text datatype and binary documents in an image field.

You can also consider that some functions works on text and not on image fields.. for example the PATINDEX function.

Regards,
Alex
Alexandre Boudreault-Ferland
Chief Technology Officer
AZUR Technologies
http://www.xicommunity.ca
http://www.xiazur.com
http://endfunction.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform