that's a pysqlite error, not SQLAlchemy, please use Python unicode objects, e.g. u'mystring', for unicode strings.
On May 26, 2014, at 1:35 PM, Afonso Rodrigues <[email protected]> wrote: > Hi, > I using do SqlAlchemy with python 2.7.6 > > I came across: > > sqlalchemy.exc.ProgrammingError: (ProgrammingError) You must not use 8-bit > bytes > trings unless you use a text_factory that can interpret 8-bit bytestrings > (like > text_factory = str). It is highly recommended that you instead just switch > your > application to Unicode strings. u'INSERT INTO algoritimo ("nomeAlgoritimo", > clas > se, "estruturaDados", "complexidadePiorCaso", "complexidadeMedioCaso", > "complexi > dadeMelhorCaso", "complexidadeEspacos", "pseudoAlgoritimo") VALUES (?, ?, ?, > ?, > ?, ?, ?, ?)' ('Ordena\xe7\xe3o Sele\xe7\xe3o', 'Algoritmo de > oderna\xe7\xe3o', ' > Array, Listas ligadas', 'O(n^2)', 'O(n^2)', 'O(n^2)', 'O(n) total, O(1) > auxiliar > ', '') > > I use: > > Base = declarative_base() > engine = create_engine('sqlite:///classificacao_pesquisa.db') > > class Algoritimo(Base): > __tablename__ = 'algoritimo' > > id = Column(Integer, primary_key=True) > nomeAlgoritimo = Column(String(50)) > classe = Column(String(250)) > estruturaDados = Column(String(50)) > complexidadePiorCaso = Column(String(50)) > complexidadeMedioCaso = Column(String(50)) > complexidadeMelhorCaso = Column(String(50)) > complexidadeEspacos = Column(String(50)) > pseudoAlgoritimo = Column(String(4000)) > > Do you have any tips? > Thank's > -- > Atenciosamente, > > Afonso Rodrigues > Analista de Sistemas > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
