Re: Use GUID instead of AutoInc

Am Wed, 23 Apr 2008 13:30:16 +0200 schrieb Koen:

When I want to use a GUID (created clientside) instead of a AutoInc
keyfield.. how should I declare the keyfield? CHAR??
Regards,
Koen

Normally the GUID created with windows api is a 16 byte binary object (or
integer with 128 bit), databases most often has GUID as own datatype. But
there are other functions available to build a character based guid which
is not compatible with guid built by windows api. Google with "create guid"
and you will get a lot of informations about it.

bye,
Helmut
.

Relevant Pages

  • Re: Replication, GUIDs and PKs
    ... I did a test and guid tables indexes to be 4 times as fragmented as bigint ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... as the subscriber databases are all 2000, and besides it isn't SQL that is ...
    (microsoft.public.sqlserver.replication)
  • Re: GUID default value
    ... > SQL Server and MS Access databases. ... We have default values for the GUID column in Oracle DB ... Autonumber GUID (called a "Replication ID"). ... I don't use Jet DDL since it's not as full-featured as DAO, ...
    (microsoft.public.access.replication)
  • Re: GUID default value
    ... > We are developing a complex system, which will run on Oracle, MS SQL ... > All the databases are to be replicated. ... > GUID column, which is filled once a new record is inserted. ... Jet has a GUID data type. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: GUID on Linux
    ... >> variations. ... starts with the MAC because that is unique to the network card (across ... Ok, at this point it is a Globally Unique IDentifier, or guid. ... objects in databases which are then moved around in other databases. ...
    (comp.os.linux.development.apps)
  • Re: DB2, MsSQL, and MS Access, How to maintain 3 data sources
    ... Don't seem to be a good idea to use GUID. ... He will have to change the data structure for all his tables and databases, ... They are guaranteed unique world-wide and make the most sense ... >>> unique customer ID's? ...
    (microsoft.public.vb.database.ado)