Version: pgAdmin 1.18.1
OS: server: Windows Server, client: Windows 7
Encodings: The database encoding is UTF8 but clients work with cp1250 encoding
Message: ERROR: invalid byte sequence for encoding "UTF8": 0xc4
If the logs contain invalid UTF8 cracters, pgAdmin starts to show error messages. At the beginning only one message is shown. When OK button is clicked, another messge is shown. This goes one indefinitely. Sometimes new messages continue to appear without user interaction (screenshot). The application has to be killed with a task manager.
Probable cause: An application sends a request encoded with cp1250 characers (eg. 0xc4) to the server. If this request fails it is written to the log. When pgAdmin reads (displays) the log it detects an encoding error and pops up a message.
Possible resoultion: Silently replace invalid bytes with '?' in the Server Status subsystem.
Marko Mahnič
