From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | zubair alam <zzia88(at)gmail(dot)com> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14211: i am enable to upload .xlsx file in my postgres database. |
Date: | 2016-06-23 17:54:52 |
Message-ID: | CAKFQuwYGRBqaQ+vrwBz-4yCXXeRE2v2kp6FvhAj9BAV7560Abg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Jun 23, 2016 at 12:56 PM, <zzia88(at)gmail(dot)com> wrote:
> 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.
>
>
Not a bug.
Native Excel files are not CSV formatted. Attempting to import them as-is
via copy will not work. You need to get the Excel data into a format that
PostgreSQL can digest. For simple cases performing a "Save As" and
changing the file type to CSV will work.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | jie.long | 2016-06-23 22:07:10 | BUG #14212: DB crash: system logger process was terminated by exception 0xFFFFFFFFwith exception 0xFFFFFFFF |
Previous Message | Vladimir Borodin | 2016-06-23 17:53:07 | Re: BUG #14189: Corrupted WAL through replication protocol |