MySQL Forums
Forum List  »  MySQL for Visual Studio

inserting a guid into a Binary(16) column doesn't insert the guid correctly
Posted by: Rajeev Ranjan
Date: July 09, 2015 01:30PM

Dear All,

I am facing one issue while saving GUID (System.Guid) in DB.

If I create a command to insert a guid into a table with a Binary(16) column to hold it and the value actually inserted into the database does not match the binary value of the guid when I retrieve back.

If you use the connector to retrieve the inserted value and compare it with the original, they won't match.

I'm using a 5.6 database.

I think this was bug in old DB but I am facing in 5.6 also. Is there any resolution of this.

Thanks for your support.

Regards,
Rajeev

Options: ReplyQuote


Subject
Views
Written By
Posted
inserting a guid into a Binary(16) column doesn't insert the guid correctly
1613
July 09, 2015 01:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.