Re: Does Postgres support BLOB datatypes? - Mailing list pgsql-general

Jeff Davis wrote:
> 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."

We do not have case-sensitive distinctions.  We are always
case-sensitive unless you use a case-insisitive operator or a function
call.


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026