More info needed on TEXT data type

Started by Chris Bitmeadalmost 25 years ago2 messagesgeneral
Jump to latest
#1Chris Bitmead
chris@bitmead.com

I want to store binary data, but I don't
want to use large objects. Can TEXT type
store binary data, if not precisely what
range of characters can be stored in it?
Is there any other data type that would
be better to use?

#2Ricardo Caesar Lenzi
ricardo@k1.com.br
In reply to: Chris Bitmead (#1)
Re: More info needed on TEXT data type

Chris Bitmead wrote:

I want to store binary data, but I don't
want to use large objects. Can TEXT type
store binary data, if not precisely what
range of characters can be stored in it?
Is there any other data type that would
be better to use?

To store binary data, you should use Large Objects, and store in table
just the large object oid. For more information about Large Objects see:
http://www.us.postgresql.org/users-lounge/docs/7.1/programmer/largeobjects.html