UTF-8 Problem ? - Mailing list pgsql-sql

From Milen Kulev
Subject UTF-8 Problem ?
Date
Msg-id 016d01c6906b$1e5c6570$0a00a8c0@trivadis.com
Whole thread Raw
Responses Re: UTF-8 Problem ?
Re: UTF-8 Problem ?
Re: UTF-8 Problem ?
Re: UTF-8 Problem ?
List pgsql-sql
Hi Listers,
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

Or

postgres=# EXECUTE  stmt (1, 1 , 1 , 'MAßßtab') ;
ERROR:  invalid UTF-8 byte sequence detected near byte 0xdf

Here are my object/statement definitions :

A) PREPARE  stmt( int, int, int, varchar) as insert  INTO  part values ($1,$2,$3,$4);

B)
postgres=# \d+ part                   Table "public.part"Column |          Type          | Modifiers | Description
--------+------------------------+-----------+-------------id1    | integer                | not null  |id2    |
integer               | not null  |id3    | integer                | not null  |filler | character varying(200) |
   | 

C)

postgres=# l\l      List of databases   Name    | Owner | Encoding
------------+-------+-----------db1        | user1 | SQL_ASCIIpostgres   | pg    | UTF8template0  | pg    |
UTF8template1 | pg    | UTF8 


How to solve my problem ?

Best Regards. Milen



pgsql-sql by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Good examples of calling slony stored procedures
Next
From: Andrew Sullivan
Date:
Subject: Re: UTF-8 Problem ?