Skip site navigation (1) Skip section navigation (2)

Re: BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß)

From: Marcus Raphelt <marcus(at)raphelt(dot)de>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
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 "sharp s" (&szlig;)
Date: 2005-07-20 09:50:49
Message-ID: 1519556741.20050720115049@raphelt.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

Am Mittwoch, 20. Juli 2005 um 10:27 schrieben Sie:

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.

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 "&szlig;" are not shown...


-- 
Mit freundlichen GrĂ¼ssen
Marcus Raphelt                            mailto:marcus(at)raphelt(dot)de


In response to

Responses

pgsql-bugs by date

Next:From: Tatsuo IshiiDate: 2005-07-20 13:04:37
Subject: Re: BUG #1775: UTF8 to ISO does not convert the german
Previous:From: Tatsuo IshiiDate: 2005-07-20 08:27:26
Subject: Re: BUG #1775: UTF8 to ISO does not convert the german

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group