| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Kasahara Kenichi" <kenjpm90(at)hotmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: There is a doubt of fatal bug on PostgreSQL 8.0.4. |
| Date: | 2005-12-09 21:23:26 |
| Message-ID: | 1732.1134163406@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Kasahara Kenichi" <kenjpm90(at)hotmail(dot)com> writes:
>> What locale is the database using? Strange comparison behavior is
>> fairly common if the locale expects a different encoding than you
>> are using...
> locale is 'C'.
Hm, it should work OK with C locale. I get apparently-correct output
on my 8.0 installation:
CREATE TABLE
INSERT 155246 1
INSERT 155247 1
INSERT 155248 1
id | name
----+--------------
1 | $B$"$"$"(B
(1 row)
id | name
----+------
(0 rows)
> client_encoding is 'SJIS'.
Um ... you said EUC_JP before. But I get the same result either way.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2005-12-09 23:30:42 | Re: [PATCHES] Patch to allow contrib/pgbench files to have blank lines |
| Previous Message | Reuben Pasquini | 2005-12-09 19:16:06 | Re: BUG #2104: pg_xlog/ trace files not reclaimed by server |