Re: UTF-8 and LIKE vs = - Mailing list 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 'てすと'?

Regards,

David