uint32 in mysql db

[mingan666]

Question: What is the proper/convenient way to handle mysql integer types?

I'm quit open into change the table structure or the generation if another type would be more appropriate. It's just a small personal project and I don't foresee any performance or size issues either way.

Background:
So, I've uses jet to generate a model from a mysql db.
All table IDs are of type uint32, but I'm having a hard time understanding how to use these values within the sql builder?

When I use EQ with the generated model it seems to works (both Picture.AlbumID and Album.ID are uint32):
INNER_JOIN(Album, Picture.AlbumID.EQ(Album.ID)))

However, when I try to use EQ with a raw uint32, it does not compile (func param: id uint32):
WHERE(Picture.AlbumID.EQ(id))

I tried to use Int(id) which I think is a jet.IntegerExpression? but the conversion does not compile either.

[trevlt]

Use UInt32 instead Int:

WHERE(Picture.AlbumID.EQ(UInt32(id)))