Hi, Sorry if this is a bit off-topic, being mostly a mysql question, but i'm hoping somebody here already encountered this problem.
I've been using NH 2.1 with mysql 5 dialect and the latest mysql .net connector and the generated column type for System.Guid was varchar(40). When I've switched to NH 3.0 I've seen that now the generated type is binary(16). >From the point of view of my application nothing has changed since NH3.0 still works fine with the old varchar(40) columns. I realize that i can leave the tables as they are now and that any performance gained from the change would probably be minor, but if the change does not require a lot of effort i would not mind doing it. Anybody knows of a method to convert the old database to the new format? I've already tried on some test data to ALTER TABLE mytable MODIFY id binary(16) but the values of the id field change, my guess being that the dash gets treated as part of the value and the result truncated. Thanks -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
