Re: Does Postgres support BLOB datatypes?

A quote from the mysql.com docs:

"The only difference between BLOB and TEXT types is that sorting and
comparison is performed in case-sensitive fashion for BLOB values and
case-insensitive fashion for TEXT values. In other words, a TEXT is a
case-insensitive BLOB."

If I understand you correctly, you need a large space to store either binary
data or text. PostgreSQL offers BYTEA and TEXT types. BYTEA is NULL-safe, so
I would reccommend it if you actually have binary data. If you're just
storing text, you can use the TEXT type which has no upper limit on size.

Regards,
Jeff

On Tuesday 08 January 2002 08:25 am, you wrote:
> Hey All,
>
> I just migrated a MySQL database to Postgres. I used the mysql2pgsql
> application to convert my MySQL data into Postgres-friendly data. The BLOB
> data I had in the MySQL database converted into the text datatype for
> postgres. I'd like to know if Postgres supports BLOBs and if not, what
> datatype should I use in place of BLOBs?
>
> Thanks for any help,
> Peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly