Best field type for replication MSSQL uniqueidentifier - Glenn F. Henriksen - com.mysql.lists.win32

1 message in com.mysql.lists.win32Best field type for replication MSSQL...

From	Sent On	Attachments
Glenn F. Henriksen	17 Jun 2001 12:37

Subject:	Best field type for replication MSSQL uniqueidentifier
From:	Glenn F. Henriksen (gle...@itl.no)
Date:	06/17/2001 12:37:03 PM
List:	com.mysql.lists.win32

Hello.

I'm making a database that I want to try to use as a replication slave with Microsoft SQL. The SQL server will read the content of the slave using ODBC.

Since I'll be creating records on the slave without the master being available I thought MSSQL's uniqueidentifier field (a GUID) would be a good idea.

But what field type should I store the GUID in on mySQL?

For now I've been using a VARCHAR(36) field to store the text version of the guid (example: '5f07fce2-d2da-46e9-aeb1-e36aabe47400'). Is this ok, or is there a better solution?

Will there be problems using a VARCHAR field as the primary key?

Thank you.

- Glenn