Hi all, 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 ? Thanks much -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] "The software required Windows 2000 or better, so i Downloaded Linux" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
