You could also implement IUserType to convert from varchar(40) to Guid and
back, so you can keep your database.
FB
> 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.
--
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.
