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

Поиск
Список
Период
Сортировка
От Marcus Raphelt
Тема BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß)
Дата
Msg-id 20050719131742.EA526F0B04@svr2.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged online:

Bug reference:      1775
Logged by:          Marcus Raphelt
Email address:      marcus@raphelt.de
PostgreSQL version: latest
Operating system:   WinXP (dev), Win2000 (server)
Description:        UTF8 to ISO does not convert the german "sharp s"
(ß)
Details:

Hi,

I currently have a iso_8859_1 app and included the opengeodb tables to have
a set of german cities and zipcodes.

http://opengeodb.sourceforge.net/index.php?FrontPage_en
I downloaded this dump:

http://prdownloads.sourceforge.net/opengeodb/opengeodb-0.2.3c-UTF8-postgres.
zip?download

They offer a Postgresql dump that can be imported without hassle, but is in
UTF8. I did several attempts using convert() to convert the city names to
iso. It works, and it also works fine on german umlauts (äöü), but it
seems like convert() does NOT convert the german "ß" / sharp s /
ß...

cheers,
marcus

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "sankar p"
Дата:
Сообщение: BUG #1776: Unable to insert datetime with fractional seconds in postgreSQL database using ODBC api
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß)