| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "prasvenk" <prasvenk(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1129: select query returns multiple results for a japanese characters |
| Date: | 2004-04-07 19:32:21 |
| Message-ID: | 26793.1081366341@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> i passed the same query to a same database but on a linux machine with
> postgres 7.4.2 it returned me around 5 rows which is not correct .
I'd guess that you are using the wrong character set encoding in the
Linux database. You did not say what encoding you think these strings
are in, but it seems possible that strings containing characters that
are illegal in the current encoding might be considered equal.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2004-04-08 14:54:49 | problem with Npgsql UNICODE <-> Latin2 |
| Previous Message | Tom Lane | 2004-04-07 19:28:38 | Re: Sequential Scan Index Bug |