Mixed client_encoding database question
От | J. Hondius |
---|---|
Тема | Mixed client_encoding database question |
Дата | |
Msg-id | 4D2B267D.6020901@rem.nl обсуждение исходный текст |
Ответы |
Re: Mixed client_encoding database question
Re: Mixed client_encoding database question Re: Mixed client_encoding database question |
Список | pgsql-general |
Hi all, We have a product with a PostgreSQLdatabase (unicode) It has a (legacy) client app that uses client_encoding = win1521 The legacy app will be around for several years. It cannot change to unicode. There also is a new client app, written in java. It uses client_encoding = unicode. The problem: if someone inputs a non-win1252 character via the new java app, the legacy app fails. PostgreSQL returns an error: character blabla of encodig UTF-8 has no equivalent in WIN1252. What are my options to stop the legacy app from failing? -Is there a setting to tell PostgreSQL to fail the character gracefully by substuting it? -Should i filter out all non win1252 charachters at the new java app and substitute them? (not so nice, i'd like to have the chars in the db) -?more? Greetings, Joek
В списке pgsql-general по дате отправления: