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. From Dedric Mauriac via <a href="http://bloghud.com" rel="noreferrer nofollow">bloghud.com</a>
Original Details
- Original on Flickr: https://www.flickr.com/photos/dedric-mauriac/4127368548/
Location
- Simulator: Woodbridge
Text Found Within Image
- taken by : Dedric Mauriac on Woodbridge (8, 2, 97)
