Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Chris Angelico
On Wed, Jun 1, 2011 at 2:31 AM, Prasad, Ramit 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 is not exactly "U

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 Benjamin Kaplan
On Tue, May 31, 2011 at 8:45 AM, Wolfgang Meiners wrote: > Am 31.05.11 13:32, schrieb Daniel Kluev: >> On Tue, May 31, 2011 at 8:40 AM, Wolfgang Meiners >> wrote: >>> metadata = MetaData('sqlite://') >>> a_table = Table('tf_lehrer', metadata, >>>    Column('id', Integer, primary_key=True), >>>  

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 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

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 > wrote: >> metadata = MetaData('sqlite://') >> a_table = Table('tf_lehrer', metadata, >>Column('id', Integer, primary_key=True), >>Column('Kuerzel', Text), >>Column('Name', Text)) > > Use Uni

Re: sqlalchemy and Unicode strings: errormessage

2011-05-31 Thread Daniel Kluev
On Tue, May 31, 2011 at 8:40 AM, Wolfgang Meiners 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. > A_record = A_class('BUM',

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 - wha