Need magic to clean strings from unconvertible UTF8

Поиск
Список
Период
Сортировка
От Andreas
Тема Need magic to clean strings from unconvertible UTF8
Дата
Msg-id 4CD62C7C.4040106@gmx.net
обсуждение исходный текст
Ответы Re: Need magic to clean strings from unconvertible UTF8  (John R Pierce <pierce@hogranch.com>)
Re: Need magic to clean strings from unconvertible UTF8  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список pgsql-general
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