From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | marcus(at)raphelt(dot)de |
Cc: | peter_e(at)gmx(dot)net, mha(at)sollentuna(dot)net, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1775: UTF8 to ISO does not convert the german |
Date: | 2005-07-20 13:04:37 |
Message-ID: | 20050720.220437.41631780.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> TI> Problem here is the result of convert(ort using utf_8_to_iso_8859_1)
> TI> is ISO-8859-1 but your database encoding is UTF-8,
>
> Not exactly, my database is in iso_8859_1, only the opengeodb-dump is
> solely available in utf-8.
> The whole thing is no problem so far, as I can convert the values in
> the application that uses the data - I just wanted to let you know.
That's surprising. Since you try to convert from UTF-8 to ISO 8859-1,
I thought you store data as UTF-8.
> TI> I guess what you want to do is:
> TI> SELECT plz, loc_id, ort from orte_de
> TI> where plz between 20000 and 30000
> TI> order by convert(ort using utf_8_to_iso_8859_1)
>
> Well, that was a fantasy-query :) just to show some "odd" values, I do
> not need that much data in the application. Currently, I cannot
> retrieve ready-converted iso data from the orte_de view, as converted
> names that contain "ß" are not shown...
Let me make sure. You store UTF-8 data in ISO 8859-1 DB?
--
Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | marco_0160 | 2005-07-20 13:36:10 | [postgres] Betrifft: An den Admin |
Previous Message | Marcus Raphelt | 2005-07-20 09:50:49 | Re: BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß ) |