On Wed, Oct 10, 2001 at 11:33:04AM +1000, Chris Bitmead wrote: > So my question is, I assume TEXT is the best data type to store > large things in, what precisely is the range of characters that > I can store in TEXT? Is it only characters ascii <= 127, or is > it only printable characters, or everything except '\0' or what?
text accepts everything except \0, and also various funtions take locale/charset info into account. Use bytea, its for 0-255, binary data. When your client library does not support it, then base64 it in client side and later decode() into place. -- marko ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org