[sqlalchemy] Re: mysql unicode issues

2007-11-15 Thread jason kirtland
david wrote: Hi Jason - Thanks a lot for the test. It is very helpful. However, when I try running it on the mysql-5.0.38 machine as a starting point for testing, (with appropriate mods for version, etc), I get very mixed results. There are 6 cases in your test: 1. use_unicode=1,

[sqlalchemy] Re: mysql unicode issues

2007-11-15 Thread david
Hi Jason - Thanks a lot for the test. It is very helpful. However, when I try running it on the mysql-5.0.38 machine as a starting point for testing, (with appropriate mods for version, etc), I get very mixed results. There are 6 cases in your test: 1. use_unicode=1, charset='utf8',

[sqlalchemy] Re: mysql unicode issues

2007-11-15 Thread david
Ok, For the time being, I seemed to have fixed/solved the current problems. 1. On the 5.0.38 system I was making a dumb mistake (when I modded your program) - when fixed, I obtained essentially the same results as you. My conclusion from this: a. have use_unicode=0, set charset='utf8' on the

[sqlalchemy] Re: mysql unicode issues

2007-11-14 Thread jason kirtland
david wrote: Hi, I can see that this has been discussed before, but I am totally baffled as to what is happening. I. ubuntu mysql version 5.0.38 with : MySQL_python-1.2.2 SQLAlchemy-03.10 python-2.5 Using SA, I can insert and select unicode data with no problem. All the mysql