Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Correct, ñ is not a valid ASCII character, so you can't encode it to ASCII. So you can, as your code does above, ignore them. Another way, namely to remove the accents, you can find here: <a href="https://stackoverflow.com/questions/517923/what-is-the-best-way-to-remove-accents-in-a-python-unicode-string">What is the best way to remove accents in a Python unicode string?</a></p> <p>But note that both techniques can result in bad effects, like making words actually mean something different, etc. So the best is to keep the accents. And then you can't use ASCII, but you can use another encoding. UTF-8 is the safe bet. Latin-1 or ISO-88591-1 is common one, but it includes only Western European characters. CP-1252 is common on Windows, etc, etc.</p> <p>So just switch "ascii" for whatever encoding you want.</p> <hr> <p>Your actual code, according to your comment is:</p> <pre><code>writer.writerow([s.encode('utf8') if type(s) is unicode else s for s in row]) </code></pre> <p>where</p> <pre><code>row = (56, u"LIMPIADOR BA\xd1O 1'5 L") </code></pre> <p>Now, I believe that should work, but apparently it doesn't. I think unicode gets passed into the cvs writer by mistake anyway. Unwrap that long line to it's parts:</p> <pre><code>col1, col2 = row # Use the names of what is actually there instead row = col1, col2.encode('utf8') writer.writerow(row) </code></pre> <p>Now your real error will not be hidden by the fact that you stick everything in the same line. This could also probably have been avoided if you had included a proper traceback.</p>
    singulars
    1. This table or related slice is empty.
    1. POPython: Convert Unicode to ASCII without errors for CSV file
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USLennart Regebro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPython: Convert Unicode to ASCII without errors for CSV file
      singulars
      1. PTQuestion
    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. COMost CSV readers can't handle UTF-8. CSV is most often read on Windows and so one of the so called ANSI encodings would seem most appropriate.
      singulars
      1. PO
      1. USDavid Heffernan
    2. COWell, I don't know about "most", but some at least. And CSV is used everywhere. Obviously an encoding that can be read by the target software needs to be used.
      singulars
      1. PO
      1. USLennart Regebro
    3. COThe thing is that the above code, using the unicode string u"LIMPIADOR BA\xd1O 1'5 L" fails miserably with the UnicodeEncodeError error also detailed above (the "ignore" flag is not working, I don't know why). In ideal conditions I'd like to get a CSV file with the full string, including the ñ.
      singulars
      1. PO
      1. USSergi
 

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