Skip site navigation (1) Skip section navigation (2)

Re: UTF-8 and LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: Joel <rees(at)ddcom(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-24 04:20:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Aug 23, 2004, at 6:58 PM, Joel wrote:

> The following should end up posted as shift-JIS, but
> テスト
> and
> てすと
> should collate the same under some contexts, since it's more-or-less
> equivalent to a variation in case.

Do you mean if you search for

   SELECT * FROM keyword where name = 'テスト';

You might expect it to return a row with name set to 'てすと'?



In response to


pgsql-general by date

Next:From: JoelDate: 2004-08-24 05:25:53
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Pablo SDate: 2004-08-24 04:13:34
Subject: Possible to insert quoted null value into integer field?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group