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

localization, encoding problem

From: "j n" <jneuschld(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: localization, encoding problem
Date: 2006-05-23 11:37:58
Message-ID: 46f93e0d0605230437w145163c9ke4d41c3576a4b825@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hellou all

i have a problem to convert data from utf8 to ascii. My localization is
slovakia and we use characters like
'á é š ť' and so on. But many times it is the same if u use 'á' or 'a'. Som
I need to translate theese special characters. Somebody told me to use
function to_ascii() but this function throws me an error : not supported
encoding to ascii.

OS  : debian
PostgreSQL : 8.1.3
configured with --enable-multibyte=UTF8

please help
thanx

Responses

pgsql-admin by date

Next:From: Adam RadlowskiDate: 2006-05-23 11:45:53
Subject: Re: sql-statement blocks maschine
Previous:From: Kouber SaparevDate: 2006-05-23 10:53:50
Subject: Re: Updatable view and default sequence values

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