


As its name, it is used to store huge volume of data as binary strings as. The table given below lists the existing pseudo-types. A pseudo-type cannot be used as a column data type, but it can be used to declare a function's argument or result type.

SUBSTR(HEX(UNHEX(REPLACE('43d597d7-2323-325a-90fc-21fa5947b9f3', '-', ''))), 9, 4), '-', About Blob In Sending Json The ConvertFrom-Json command is an excellent way to. The PostgreSQL type system contains a number of special-purpose entries that are collectively called pseudo-types. This piece of SQL run on Mysql 5.7 helped lock in the concept for me: SELECT
CONVERT BINARY COLUMN TO STRING PSEQUEL HOW TO
If you are looking for the opposite, i.e., how to convert from string to binary, perhaps to do a join or something, this is covered here : Convert UUID to/from binary in Node
