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

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

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" (&szlig;)
Date: 2005-07-19 15:42:34
Message-ID: (view raw, whole thread or download thread mbox)
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"
> (&szlig;)
> Details: 
> Hi,
> I currently have a iso_8859_1 app and included the opengeodb 
> tables to have a set of german cities and zipcodes.
> I downloaded this dump:
> 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 / &szlig;...

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.



pgsql-bugs by date

Next:From: nicolasDate: 2005-07-19 19:41:29
Subject: BUG #1777: Cache lookup filed
Previous:From: sankar pDate: 2005-07-19 14:15:13
Subject: BUG #1776: Unable to insert datetime with fractional seconds in postgreSQL database using ODBC api

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