> > > 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
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).
In response to
pgsql-general by date
|Next:||From: Joel||Date: 2004-08-24 06:38:26|
|Subject: Re: UTF-8 and LIKE vs =|
|Previous:||From: Thomas Hallgren||Date: 2004-08-24 05:29:34|
|Subject: Re: Unsupported 3rd-party solutions (Was: Few questions|