adding hexadecimal values
807607Nov 14 2006 — edited Nov 16 2006I am importing from a flat file to a mysql db. I am having trouble with the primary keys. In the delimited file I read "x1234567887654321123456788765a321". This is a hexadecimal. I am trying to insert this value in a field of CHAR(16). Any ideas on how to solve this or where I might find the solution would be greatly appreciated.