Postgres Pro
Downloads
Home   >   mailing lists

BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß) - Mailing list pgsql-bugs

From Marcus Raphelt
Subject BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß)
Date
Msg-id 20050719131742.EA526F0B04@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
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 by date:

Previous
From: "sankar p"
Date:
Subject: BUG #1776: Unable to insert datetime with fractional seconds in postgreSQL database using ODBC api
Next
From: "Magnus Hagander"
Date:
Subject: Re: BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß)