On Wed, May 12, 2004 at 02:50:55PM -0700, Larry Lowry wrote: > Well I'm trying to move to MySQL from the MS SQL Server > world. Most data elements are easy except for the uniqueidentifier. > > In the MySQL world what is the preferred/best way to store a > uniqueidentifier? The easiest would just be a char(36).
If you have unique ids that are 36 characters, then use a char(36). That seems like the obvious thing to do. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]