Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It took some time but I think I found the answer.</p> <p>I assumed the word was supposed to be Akvaléir. I found a page description about that, in French. When I used your code snippet I had a string like</p> <pre><code>&gt;&gt;&gt; fileinfo.filename 'Akval\x82ir, La police - The Font - Fr - En.pdf' &gt;&gt;&gt; </code></pre> <p>That didn't work at UTF8, Latin-1, CP-1251 or CP-1252 encodings. I then found that CP863 was a possible Canadian encoding, so perhaps this was from French Canada.</p> <pre><code>&gt;&gt;&gt; print unicode(fileinfo.filename, "cp863").encode("utf8") Akvaléir, La police - The Font - Fr - En.pdf &gt;&gt;&gt; </code></pre> <p>However, I then read the <a href="http://www.pkware.com/documents/casestudies/APPNOTE.TXT" rel="noreferrer">Zip file format specification</a> which says</p> <blockquote> <p>The ZIP format has historically supported only the original IBM PC character encoding set, commonly referred to as IBM Code Page 437.</p> <p>...</p> <p>If general purpose bit 11 is set, the filename and comment must support The Unicode Standard, Version 4.1.0 or greater using the character encoding form defined by the UTF-8 storage specification.</p> </blockquote> <p>Testing that out gives me the same answer as the Canadian code page</p> <pre><code>&gt;&gt;&gt; print unicode(fileinfo.filename, "cp437").encode("utf8") Akvaléir, La police - The Font - Fr - En.pdf &gt;&gt;&gt; </code></pre> <p>I don't have a Unicode encoded zip file and I'm not going to create one to find out, so I'll just assume that all zip files have the cp437 encoding.</p> <pre><code>import shutil import zipfile f = zipfile.ZipFile('akvaleir.zip', 'r') for fileinfo in f.infolist(): filename = unicode(fileinfo.filename, "cp437") outputfile = open(filename, "wb") shutil.copyfileobj(f.open(fileinfo.filename), outputfile) </code></pre> <p>On my Mac that gives</p> <pre><code> 109936 Nov 27 01:46 Akvale??ir_Normal_v2007.ttf 25244 Nov 27 01:46 Akvale??ir, La police - The Font - Fr - En.pdf </code></pre> <p>which tab-completes to</p> <pre><code>ls Akvale\314\201ir </code></pre> <p>and shows up with a nice 'é' in my file browser.</p>
    singulars
    1. This table or related slice is empty.
    1. POExtract files with invalid characters in filename with Python
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndrew Dalke
    1. USAndrew Dalke
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes, you have to know the source encoding in advance. The ZIP format contains absolutely no information from which you can work out what encoding filenames are using. Whilst Macs and most modern Linuxen sensibly use UTF-8 for their filesystems and inside ZIP, Windows machines use the system code page, which is locale-dependent and never UTF-8. It's a real headache.
      singulars
      1. PO
      1. USbobince
    2. CO@dalke, thanks for your info. How can I detect which encoding a string uses in python program?
      singulars
      1. PO
      1. USjack
    3. CORead the spec and found that ZIP uses cp437 or utf-8. There is a flag (bit 11) which specifies which of those two was used. I haven't written code to check for that.
      singulars
      1. PO
      1. USAndrew Dalke
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload