[sqlalchemy] Re: Very odd utf8 problem

2009-10-28 Thread Yo'av Moshe
created the new DB with utf8 collation, and passed moved.py the right SA parameters. Thank you! Yo'av 2009/10/14 Yo'av Moshe bje...@gmail.com Hey, thanks. I tried to add the encoding parameter with the latin1 value, but it messed up everything and all of content was shown wrong. I decided

[sqlalchemy] Re: Very odd utf8 problem

2009-10-14 Thread Yo'av Moshe
Michael Bayer mike...@zzzcomputing.com On Oct 12, 2009, at 7:22 PM, Yo'av Moshe wrote: Hey, Yes, I'm using a MySQL 5. I understand that the problem is probably happening because of some data I have in my DB, but it's seems odd to me since everything I have in this DB was created using SA

[sqlalchemy] Re: Very odd utf8 problem

2009-10-12 Thread Yo'av Moshe
works except for this search query, and how come SA created data it cannot read, and why the hell it works the second time ... :( Yo'av 2009/10/11 Michael Bayer mike...@zzzcomputing.com On Oct 11, 2009, at 2:29 PM, Yo'av Moshe wrote: No, the error is an UnicodeDecodeError (http://paste2.org/p

[sqlalchemy] Re: Very odd utf8 problem

2009-10-11 Thread Yo'av Moshe
, Yo'av 2009/10/10 Michael Bayer mike...@zzzcomputing.com On Oct 10, 2009, at 3:43 AM, Yo'av Moshe wrote: Any ideas? I still don't understand why the query is failing even when I'm using a unicode object. whats the error ? EOF in multi-line statement ? thats not a SQLAlchemy error

[sqlalchemy] Re: Very odd utf8 problem

2009-10-10 Thread Yo'av Moshe
Any ideas? I still don't understand why the query is failing even when I'm using a unicode object. Yo'av 2009/10/8 Yo'av Moshe bje...@gmail.com Thanks, I didn't know about that awful IPython bug... I checked, and apparently my website is already doing the SA query with a unicode object

[sqlalchemy] Very odd utf8 problem

2009-10-07 Thread Yo'av Moshe
Hey! I'm using SA in a TurboGears website for quite a long time now, and it was working great for a long time, until now! In my website users can upload articles, edit them, etc... The problem is with the search function - for some reason, searching for a certain word in my language (Hebrew)

[sqlalchemy] Re: Very odd utf8 problem

2009-10-07 Thread Yo'av Moshe
Um, why? It's true that it doesn't fail when I add that 'u', but it returns nothing (an empty list). What's that REPL? Yo'av 2009/10/7 Michael Bayer mike...@zzzcomputing.com Yo'av Moshe wrote: Hey! I'm using SA in a TurboGears website for quite a long time now, and it was working

[sqlalchemy] Re: Very odd utf8 problem

2009-10-07 Thread Yo'av Moshe
...@cl.uni-heidelberg.de On Wed, Oct 07, 2009 at 07:55 -0700, Yo'av Moshe wrote: See what I mean here (it's me running the same query twice in IPython): http://paste2.org/p/457059 What can cause this behavior?! I can't think of anything! I guess that one of my users has uploaded some article