This post was formerly published at my beloved old blog "On the quest of a DBA's adventure......"
Over a migration project for Pivotal data, I was asked to keep the primary key for the record migrated. In Pivotal world, default keys are in binary(8) type, but the requirement was set that legacy key should be kept in varchar for the majority of the legacy system.
So, our topic here is: Can we convert binary into varchar, back and forward? we keep it which means we will, or may, or we have no idea if (more likely) we need back at some stage later on.
I have some rearsch, this is what I found:
No comments:
Post a Comment