Re: 65279 Invisible ASCII Character

Поиск
Список
Период
Сортировка
От ramsiddu007
Тема Re: 65279 Invisible ASCII Character
Дата
Msg-id CA+zEy78wpcgN3W+46E3E1030vZZzCOe-sWqKeNze9i-svjNs9g@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Thanks, I'll look into it. 

On Tue, Jul 17, 2018 at 3:42 PM Christoph Moench-Tegeder <cmt@burggraben.net> wrote:
## ramsiddu007 (ramsiddu007@gmail.com):

>  If i remove first character it's run. That first
> character is invisible, I have checked that *ascii* value, it is *65279*.

That's not an ASCII-value, ASCII has 8 bits at most.
What you've got there is a UTF-16 Byte Order Mark: 65279 is 0xfeff
(one of the well-known constants).
I'd suggest you get your editor configured to write files without
BOM. Maybe there's a workaround via locale settings - but I have
no machine with an UTF-16 locale available. Another approach is using
recode on your files before concatenating.

This question isn't really for pgsql-hackers - I'm redirecting to -general.

Regards,
Christoph

--
Spare Space


--
Best Regards:
Ramanna Gunde

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: PG backup check
Следующее
От: Fabio Pardi
Дата:
Сообщение: Re: Query to monitor index bloat