Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 20040824.154718.10295780.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (Joel <rees@ddcom.co.jp>)
Responses Re: UTF-8 and LIKE vs =
List pgsql-general
> Just want to check this --
>
> > > > > 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 'てすと'?
> > >
> > > If the locale machinery iw functioning correctly (and if I understand
> > > correctly), there ought to be a setting that would allow those to
> > > collate to the same point.
> > >
> > > I'm not sure what the settings would be, or if it's fully funtional yet.
> > > Maybe Tatsuo would know? (Hope he doesn't mind me CC-ing him.)
> >
> > I'm not sure what the point of the original question was, but I know
> > that
> >
> >     SELECT * FROM keyword where name = 'テスト';
> >
> > should work if locale = C and encoding is either EUC_JP or UTF-8 on my
> > standard Linux box (of course I did initdb --no-locale).
>
> (query is katakana)
>
>     SELECT * FROM keyword where name = 'テスト';
>
>
> returns a record whose name field is 'てすと' (hiragana)?
>
> Doesn't this require some LC_COLLATE flag?

No.

> (I suppose I should try this myself.)

Actually there's a similar regression test case in
src/test/mb/sql/euc_jp.sql(expected result is
src/test/mb/expected/euc_jp.sql).
--
Tatsuo Ishii

pgsql-general by date:

Previous
From: Joel
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: Secrétariat
Date:
Subject: Re: pg_dump/psql fails on win32 beta 8.0