Alexander Farber wrote: > I started to prepare a test case and realized I had a bug. > So convert() works for me, sorry for my previous message! In any case, it's probably saner if you SET client_encoding at the start of the session instead of using convert() everywhere. The server_encoding should be correctly set to Win1251 though! (Using SQL_ASCII, while not technically incorrect, is probably not doing you any favor). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.