Need magic to clean strings from unconvertible UTF8

Поиск
Список
Период
Сортировка
Hi,

somehow there have unconvertible characters sneaked into my DB.
Very probaply they came in via Imports from MS-Access.

Access doesn't complain but when I try to export stuff with pgAdmin to
csv I get an error that some char is not representable in the local charset.

I can find the problematic rows.
How could I delete every char in a string that can't be converted to
WIN1252?


Regards
Andreas

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Libpq is very slow on windows but fast on linux.
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Need magic to clean strings from unconvertible UTF8