Changes

Jump to: navigation, search

PostgreSQL Adapter Project - Resources

4 bytes removed, 10:43, 6 December 2010
PostgreSQL Specifications
* Data Types
: Binary - hex
:: PostgreSQL can not store values of more than several thousands bytes within any data-type except large objects, nor can binary data be easily entered within single quotes. Instead, large objects (BLOB) are used to store very large values and binary data. From PostgreSQL documentation “String Functions and Operators”[6] we catch the function ENCODE(data bytea, type text). This function encodes binary data to an ASCII-only representation. The supported types are: base64, hex, escape. [http://lab.lonerunners.net/blog/binary-data-fetching-through-sqli]
: bit & bit varying - for storing binaries [http://www.postgresql.org/docs/8.1/static/datatype-bit.html]
1
edit

Navigation menu