[cspay-dev] Problema unicode inserare date DB

[Lupescu Grigore]

 python script.py


({'disc_id': 21L}, u'Sisteme de operare', u'C', u'L', u'R', 3.0, u'CA', 145.0, 5                           .0, '', 3.0, 0.0, 66.0, u'3s', '', u'po', u'Purdila O.', u'Purdil\u0103 O.', u'4                           CA', u'mi', u'11-14', u'EC101', 1, 1)


Traceback (most recent call last):
  File "script.py", line 47, in ?
    db_writer.db_write_line(line,index_line)  #pass the line and its number
  File "/home/projects/cspay/local-repo/branches/dodo/test-xlrd/db_writer.py", l                           ine 61, in db_write_line
    cursor.executemany ("""INSERT INTO ore VALUES (%s,%s)""",[tuple_db,tuple_db]                           )
  File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 199, in execu                           temany
    qargs = db.literal(args)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 232, in l                           iteral
    return self.escape(o, self.encoders)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 179, in u                           nicode_literal
    return db.literal(u.encode(unicode_literal.charset))
UnicodeEncodeError: 'latin-1' codec can't encode character u'\u0103' in position                            6: ordinal not in range(256)
cspay at anaconda:~/local-repo/branches/dodo/test-xlrd$

Datele nu pot fi inserate in baza de date datorita faptului ca ele sunt unicode si in cazul in care nu sunt intre 0-255(ascii) imi da eroare

Ce se vede dupa comanda e rezultatul comenzii "print line" -> anume cum sunt salvate datele de pe o linie din fisierul XLS intr-o lista
(u->unicode)

Nu stiu care metoda e mai simpla si mai buna in cazul de fata ... Cert e ca am incercat mai multe dar fara rezultat

http://diveintopython.org/xml_processing/unicode.html
import sys
sys.setdefaultencoding('iso-8859-1') -> da eroare cum ca nu exista functia
#!/usr/bin/env python
# -*- coding: UTF-8 -*-
title.encode('ascii','ignore')->nu a mers







_________________________________________________________________
More than messages–check out the rest of the Windows Live™.
http://www.microsoft.com/windows/windowslive/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rosedu.org/pipermail/cspay-dev/attachments/20090717/8a27ce2d/attachment.htm>