From: | zzia88(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14211: i am enable to upload .xlsx file in my postgres database. |
Date: | 2016-06-23 16:56:27 |
Message-ID: | 20160623165627.17239.61644@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14211
Logged by: Zubair Alam
Email address: zzia88(at)gmail(dot)com
PostgreSQL version: 9.5.3
Operating system: windows7-x64(64 bit)
Description:
copy person(first_name,last_name,dob,email) from 'D:\person\person.xlsx'
with delimiter ',' csv header encoding 'WIN1256';
my client client_encoding is:- UNICODE
i am running this code on my host machine
At the runtime i am getting this error:-ERROR: invalid byte sequence for
encoding "WIN1256": 0x00
CONTEXT: COPY person, line 1
if i am providing csv header encoding :-'UNICODE(UTF8) then i am getting
this error:-ERROR: invalid byte sequence for encoding "UTF8": 0x00
CONTEXT: COPY person, line 1
********** Error **********
ERROR: invalid byte sequence for encoding "UTF8": 0x00
SQL state: 22021
Context: COPY person, line 1
Please solve this problem as soon as possible and test that code then
provide me that code or solution.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-06-23 17:04:07 | Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column |
Previous Message | Alvaro Herrera | 2016-06-23 16:54:39 | Re: about and feature matrix on site |