Im researching switching a production database system to use UUID's instead of
AUTO_INCREMENT columns for various ids. I've looked at various MySQL
documentation, and it seems to be what i want.
This change will really affect 2 separate database servers. Both are using
InnoDB tables. One is running MySQL 4.1.3-beta on solaris, and the other is
running 4.1.8-Max on Redhat Linux.
From what i've been reading, the only thing i cant determine is what column
type to use to store the UUID's. These will be foreign keys between some
tables, and the unique ids in all tables for this system.
Should i be using BINARY() columns ?
Senior Programmer, WIREData Inc.
"The software required Windows 2000 or better, so i Downloaded Linux"