hexadecimal heidi

miguelaobsimoes@gmail.com's profile image miguelaobsimoes@gmail.com posted 2 years ago in General Permalink

Hi, I'm trying to send data from my program to my database, but I'm having the problem, because I send values in hexadecimal from my program, for example: 730C404A and heidi can't receive this value. Maybe I'm putting the data type in heidi's table wrong?? Do not know....

TTSneko's profile image TTSneko posted 2 years ago Permalink

No need for multiple posts.

You should go read up on the different data types and how they are stored and retreieved. That is nothing HeidiSQL does for you, YOU have to script it! Offering a quick solution will not help you as you will come back every five minutes instead of investing a little time for your own education.

Sounds stupid? Well, there are two different methods of how to get what you want. Both are valid, both are easy. But both have their own quirks and it depends on YOU to know what is better to use (see HEX & UNHEX in context of CHAR or BINARY filed declarations).

TTSneko's profile image TTSneko posted 2 years ago Permalink

typo: "... CHAR or BINARY field declarations)."

Please login to leave a reply, or register at first.