UNICODE-encoded database does not accept umlaut-characters.
От
Erwin Brandstetter
Тема
UNICODE-encoded database does not accept umlaut-characters.
Дата
Msg-id
Xns9472ECB0F7814BrandstetterFalterat@213.129.232.14
Список
Дерево обсуждения
UNICODE-encoded database does not accept umlaut-characters. Erwin Brandstetter <Brsaz@gmzx.at>
Re: UNICODE-encoded database does not accept umlaut-characters. Tom Lane <tgl@sss.pgh.pa.us>
Created a new 7.4 database. # create database foo with encoding = UNICODE; Then tried to restore my dump from pg 7.2 which was SQL-ASCII or Latin1 encoded (cant tell which of the two, only got the dump of the old database left after upgrading postgresql.) Succeeded creating the objects, but no data was restored, instead postgresql complained about illegal UNICODE characters. Also export of an MS-Access Database with pgAdmin 1.6 failed with the same errors. Created a new database with encoding = Latin1. Everything worked fine. This is a shame, as UNICODE was chosen to avoid future problems with exotic characters. But I cant get it working because of this very problem! Is this a bug? Any workarounds? Regards & TIA Erwin -- no z in my mail.
В списке pgsql-general по дате отправления