Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you decide the length of GUID field?
Message
De
05/08/2008 09:24:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01336497
Message ID:
01336540
Vues:
26
>It seems you're confusing surrogate keys with GUIDs. The size of GUID is fixed because it's a 16-byte (128-bit) number. A character hexadecimal representation of a GUID is from 32 to 38 characters in lengh depending on a format
>
>32 - 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
>36 - 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'
>38 - '{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}'
>
>Check http://www.berezniker.com/content/pages/visual-foxpro/generate-guid
>

Hi,

You are right about the definition of GUID and thanks for the link.

Btw, lets just talk about surrogated key, I am interested to know how do you normally decide a length?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform