Re: How to find freak UTF-8 character?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: How to find freak UTF-8 character?
Дата
Msg-id 20111003144446.GB53886@shinkuro.com
обсуждение исходный текст
Ответ на Re: How to find freak UTF-8 character?  (Leif Biberg Kristensen <leif@solumslekt.org>)
Список pgsql-general
On Sat, Oct 01, 2011 at 11:16:06PM +0200, Leif Biberg Kristensen wrote:
> But thank you for the idea, I think that I will strip out at least any ‎
> entities from text entered into the database.

If you're getting &lrm, you might want to check for ZWJ and ZWNJ code
points too.  They're nasty because by definition they don't display
("ZW" stands for "Zero Width".  If you ever actually have to spend
time understanding how things got this way in Unicode, you will have
my sympathy).

> By the way, is there a setting in psql that will output unprintable characters
> as question marks or something?

Not to my knowledge, although I'd expect the terminal driver to have
control over this, no?

A

--
Andrew Sullivan
ajs@crankycanuck.ca

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

Предыдущее
От: Diego Augusto Molina
Дата:
Сообщение: Re: [Solved] Generic logging system for pre-hstore using plperl triggers
Следующее
От: senthilnathan
Дата:
Сообщение: How to avoid TimeLine increase / Change on recovery?