UTF-8 Problem ?

Поиск
Список
Период
Сортировка
Искать
От
Milen Kulev
Тема
UTF-8 Problem ?
Дата
Msg-id
016d01c6906b$1e5c6570$0a00a8c0@trivadis.com
Список
Дерево обсуждения
UTF-8 Problem ? "Milen Kulev" <makulev@gmx.net>
Re: UTF-8 Problem ? Andrew Sullivan <ajs@crankycanuck.ca>
Re: UTF-8 Problem ? Volkan YAZICI <yazicivo@ttnet.net.tr>
Re: UTF-8 Problem ? Aarni Ruuhimäki <aarni@kymi.com>
Re: UTF-8 Problem ? Thomas Beutin <psql@laokoon.IN-Berlin.DE>
Re: UTF-8 Problem ? "Milen Kulev" <makulev@gmx.net>
Re: UTF-8 Problem ? Thomas Beutin <psql@laokoon.IN-Berlin.DE>
Re: UTF-8 Problem ? Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Christopher Browne
Дата:
От: Andrew Sullivan
Дата:
Сообщение: Re: UTF-8 Problem ?
FAQ