65279 Invisible ASCII Character

From: ramsiddu007 <ramsiddu007(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Monalee Bhandge <monalee(dot)bhandge(at)epps-erp(dot)com>
Subject: 65279 Invisible ASCII Character
Date: 2018-07-17 09:30:43
Message-ID: CA+zEy7-2+2tiSRq+Sv8qbhRfWY0tK3=u5zJpgYKTor2-bD_2iw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers

Hi all,
Today i got one problem what i have saved more that one procedures in
a folder. After i have concatenate those files into single file through
shell script. After am trying to run that single file in my server, it was
showing syntax error. If i remove first character it's run. That first
character is invisible, I have checked that *ascii* value, it is *65279*.
How can i overcome this problem. I want to run my single file without this
error.

By below command i am concatenating individual scripting files to single.
*:> cat *.* > <file_name>.sql*

select ascii('');

select chr(65279);

select length('');

Plz. give me suggestions, it's blocker to my work.

Thanking you,

--
*Best Regards:*
Ramanna Gunde

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-07-17 10:12:47 Re: 65279 Invisible ASCII Character
Previous Message Fabio Pardi 2018-07-17 08:14:32 Re: Streaming replication connection break - unexpected EOF on standby connection

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-07-17 10:12:47 Re: 65279 Invisible ASCII Character
Previous Message Magnus Hagander 2018-07-17 09:25:25 Re: PG backup check

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2018-07-17 09:58:23 Re: [HACKERS] advanced partition matching algorithm for partition-wise join
Previous Message Kyotaro HORIGUCHI 2018-07-17 09:24:22 Re: [HACKERS] WAL logging problem in 9.4.3?