pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Volkan YAZICI <yazicivo@ttnet.net.tr>
To: Milen Kulev <makulev@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: UTF-8 Problem ?
Date: Thu, 15 Jun 2006 14:08:15 +0300
Message-ID: <20060615110815.GB2469@alamut.tdm.local> (raw)
In-Reply-To: <016d01c6906b$1e5c6570$0a00a8c0@trivadis.com>
References: <016d01c6906b$1e5c6570$0a00a8c0@trivadis.com>

On Jun 15 01:01, Milen Kulev wrote:
> I want to insert some german specific characters (umlaut characters)
> into a table, but I am getting  the following 
> Error message:
> postgres=# EXECUTE  stmt (1, 1 , 1 , 'GrĂ¼n')  ;
> ERROR:  invalid UTF-8 byte sequence detected near byte 0xfc
> ...
> postgres=# l\l
>        List of databases
>     Name    | Owner | Encoding
> ------------+-------+-----------
>  db1        | user1 | SQL_ASCII
>  postgres   | pg    | UTF8
>  template0  | pg    | UTF8
>  template1  | pg    | UTF8

Did you set your client_encoding properly too? (Also, assuming that
your terminal supports the related client encoding.)


Regards.



view thread (8+ messages)  latest in thread

Message-ID: <20060615110815.GB2469@alamut.tdm.local>
Permalink:  ../20060615110815.GB2469@alamut.tdm.local/
Also on:    postgresql.org/message-id/20060615110815.GB2469@alamut.tdm.local

 · 

reply

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: yazicivo@ttnet.net.tr, makulev@gmx.net
  Subject: Re: UTF-8 Problem ?
  In-Reply-To: <20060615110815.GB2469@alamut.tdm.local>

* 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