From: Kai Hessing <kai.hessing@hobsons.de>
To: pgsql-sql@postgresql.org
Subject: Problem with SQL_ASCII
Date: Thu, 03 Mar 2005 15:23:04 +0100
Message-ID: <38okucF5od9psU1@individual.net> (raw)
I have a little problem in PostgreSQL 7.39 (and previous). Our database
is in 'SQL_ASCII'-Format. When doing SQL-Selects all special Characters
(e.g. äöüß, etc...) are ASCII encoded (sure they are). Is there any
function to change the encoding to - let's say - LATIN1 (reverse
function for to_ascii($text, 'LATIN1'))?
Otherwise, is it possible to write a function which just uses a
character replacement? I can image a select like:
Name in Table contains 'Ernst & Young AG', select is:
SELECT from_ascii(name, 'LATIN1') FROM table;
And output should be 'Ernst & Young AG'
We do this now in a second step with a find/replace tool...
Anyone any idea? Thanks and
*greets*
Kai...
--
GnuPG-PublicKey -> http://www.hobsons.de/pgp/kai_hessing.asc
Gut ist nicht Nichtfreveln, sondern nicht einmal freveln wollen.
(Demokrit, um 460 v. Chr.)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kai.hessing@hobsons.de
Subject: Re: Problem with SQL_ASCII
In-Reply-To: <38okucF5od9psU1@individual.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox