UTF-8 Problem ?

Поиск
Список
Период
Сортировка
От Milen Kulev
Тема UTF-8 Problem ?
Дата
Msg-id 016d01c6906b$1e5c6570$0a00a8c0@trivadis.com
обсуждение исходный текст
Ответы Re: UTF-8 Problem ?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: UTF-8 Problem ?  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Re: UTF-8 Problem ?  (Thomas Beutin <psql@laokoon.IN-Berlin.DE>)
Re: UTF-8 Problem ?  (Aarni Ruuhimäki <aarni@kymi.com>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Good examples of calling slony stored procedures
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: UTF-8 Problem ?