Got sha1 checksum in hexadecimal format(40 characters). Need help to convert hex chars to byte array in mysql.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
There is no such thing as an "array" in MySQL.
Perhaps you want
UNHEX(SHA1("stuff")) ? That will provide a 20 bytes, and could be stored, for example, into a