Index: doc/src/sgml/datatype.sgml
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/datatype.sgml,v
retrieving revision 1.60
diff -c -r1.60 datatype.sgml
*** doc/src/sgml/datatype.sgml 2001/08/31 01:55:25 1.60
--- doc/src/sgml/datatype.sgml 2001/09/04 03:15:49
***************
*** 84,89 ****
--- 84,95 ----
+ bytea
+
+ binary data
+
+
+
character(n)
char(n)
fixed-length character string
***************
*** 782,788 ****
text
Variable unlimited length
!
--- 788,798 ----
text
Variable unlimited length
!
! bytea
! binary data
!
!
***************
*** 827,832 ****
--- 837,855 ----
does not require an explicit declared upper limit on the size of
the string. Although the type text is not in the SQL
standard, many other RDBMS packages have it as well.
+
+
+
+ The bytea data type allows storage of binary data,
+ specifically allowing storage of NULLs which are entered as
+ '\\000'>. The first backslash is interpreted by the
+ single quotes, and the second is recognized by bytea> and
+ preceeds a three digit octal value. For a similar reason, a
+ backslash must be entered into a field as '\\\\'> or
+ '\\134'>. You may also have to escape line feeds and
+ carriage return if your interface automatically translates these. It
+ can store values of any length. Bytea> is a non-standard
+ data type.