From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Marcus Raphelt" <marcus(at)raphelt(dot)de>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #1775: UTF8 to ISO does not convert the german "sharp s" (ß ) |
Date: | 2005-07-19 15:42:34 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE6C778F@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> Bug reference: 1775
> Logged by: Marcus Raphelt
> Email address: marcus(at)raphelt(dot)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 / ß...
PostgreSQL 8.0 does not support UTF8 on Win32. You will need to convert the file before you load it into the database - look at for example the GNU iconv program to do this.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | nicolas | 2005-07-19 19:41:29 | BUG #1777: Cache lookup filed |
Previous Message | sankar p | 2005-07-19 14:15:13 | BUG #1776: Unable to insert datetime with fractional seconds in postgreSQL database using ODBC api |