I was going a bit nuts trying to find out why I was getting an error when adding one of my inventory items to the database. I have a primary key that contains a varchar(64) data type as one if it’s keys. One item got in the database that was 63 characters long. I tried to add another item with the same name, except that it had a trailing space. It appears that MySQL thinks that this is the same name without the trailing space. It appears that it may be related to Bug #14131. I’ll look into changing the collation from PADSPACE to NOPAD.
posted by Dedric Mauriac on Woodbridge using a blogHUD : [blogHUD permalink]