Re: how is text-equality handled in postgresql? - Mailing list pgsql-general

From Vick Khera
Subject Re: how is text-equality handled in postgresql?
Date
Msg-id CALd+dcfoW1ciPB429xOcDqX=uVJ3-SDE3phAEgoU5c4Dzsc74Q@mail.gmail.com
Whole thread Raw
In response to how is text-equality handled in postgresql?  (Gábor Farkas <gabor.farkas@gmail.com>)
List pgsql-general

On Wed, Jan 15, 2014 at 4:10 AM, Gábor Farkas <gabor.farkas@gmail.com> wrote:
or in other words, when are two varchars equal in postgres? when their
bytes are? or some algorithm is applied?

On this topic, when I write my strings to the DB and search from the DB, should I canonicalize them first as NKFC (or some other), or just let the DB figure it out? In my specific case I use perl DBI with place holders to submit my queries.

pgsql-general by date:

Previous
From: Felix.徐
Date:
Subject: Re: How are pg_operator and pg_type related with each other?
Next
From: Ming Li
Date:
Subject: Re: non-zero xmax yet visible