Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Chris Withers
Hi Wolfgang, On 30/05/2011 22:40, Wolfgang Meiners wrote: I am trying to build an application using sqlalchemy. You're likely to get much better help here: http://www.sqlalchemy.org/support.html#mailinglist When you post there, make sure you include: - what python version you're using -

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Daniel Kluev
On Tue, May 31, 2011 at 8:40 AM, Wolfgang Meiners wolfgangmeiner...@web.de wrote: metadata = MetaData('sqlite://') a_table = Table('tf_lehrer', metadata,    Column('id', Integer, primary_key=True),    Column('Kuerzel', Text),    Column('Name', Text)) Use UnicodeText instead of Text.

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Wolfgang Meiners
Am 31.05.11 13:32, schrieb Daniel Kluev: On Tue, May 31, 2011 at 8:40 AM, Wolfgang Meiners wolfgangmeiner...@web.de wrote: metadata = MetaData('sqlite://') a_table = Table('tf_lehrer', metadata, Column('id', Integer, primary_key=True), Column('Kuerzel', Text), Column('Name', Text))

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Wolfgang Meiners
Am 31.05.11 11:55, schrieb Chris Withers: Hi Wolfgang, On 30/05/2011 22:40, Wolfgang Meiners wrote: I am trying to build an application using sqlalchemy. You're likely to get much better help here: http://www.sqlalchemy.org/support.html#mailinglist When you post there, make sure you

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Wolfgang Meiners
I just found a second method on http://docs.python.org/howto/unicode you can use tho module codecs and then simply write import codecs f = codecs.open('unicode.rst', encoding='utf-8') for line in f: print repr(line) Wolfgang -- http://mail.python.org/mailman/listinfo/python-list

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Benjamin Kaplan
On Tue, May 31, 2011 at 8:45 AM, Wolfgang Meiners wolfgangmeiner...@web.de wrote: Am 31.05.11 13:32, schrieb Daniel Kluev: On Tue, May 31, 2011 at 8:40 AM, Wolfgang Meiners wolfgangmeiner...@web.de wrote: metadata = MetaData('sqlite://') a_table = Table('tf_lehrer', metadata,    Column('id',

RE: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Prasad, Ramit
line = unicode(line.strip(),'utf8') and now i get really utf8-strings. It does work but i dont know why it works. For me it looks like i change an utf8-string to an utf8-string. I would like to point out that UTF-8 is not exactly Unicode. From what I understand, Unicode is a standard while

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Chris Angelico
On Wed, Jun 1, 2011 at 2:31 AM, Prasad, Ramit ramit.pra...@jpmchase.com wrote: line = unicode(line.strip(),'utf8') and now i get really utf8-strings. It does work but i dont know why it works. For me it looks like i change an utf8-string to an utf8-string. I would like to point out that UTF-8

sqlalchemy and Unicode strings: errormessage

2011-05-30 Thread Wolfgang Meiners
Hi, I am trying to build an application using sqlalchemy. in principle i have the structure #== from sqlalchemy import * from sqlalchemy.orm import * metadata = MetaData('sqlite://') a_table = Table('tf_lehrer', metadata, Column('id', Integer,