mysql - Is it OK to use Hex's as database IDs? -

I have just been assigned a database schema which seems a little awkward for me, the database sits behind a soap web service and I have found that all table ids are string in hex format

example: 0x1D283F

I have to duplicate data in a MySQL database I have never used hex as an ID Is, so I do not know that this is a good idea / bad It does not matter or it does not matter. I'm assuming that auto impressions will not work here, so I think it's a bad idea.

I can convert them to an integer, or leave them, but what is the effect of this.

First of all, whether the number is a 'hexadecimal' or 'decimal', it is a matter of external presentation , It does not change the storage format. Using a string of numbers as a database index is clearly disabled and can prevent some DB features and customization, though.

Therefore, convert the hex string to a plain integer and use it as a database index and you will be fine.