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 stuff looks like it is set to "latin1", the database wasn't
created with any special options etc., I added nothing special to the
connection string, but if I insert Russian characters (encoded in
utf-8) into a column with type Unicode, It *works* and if I select, I
get back the correct data. It even looks fine with the "mysql"
program.
II.
Now, I try the same thing on a red-hat system
with:
mysql version 4.1.9
MySQL_python-1.2.2
SQLAlchemy-03.10
python-2.4.2
I realize I am changing two things (besides the os): mysql version,
and python version.
BUT, I can't get *anything* with sa and unicode and mysql to work!
I ended up creating the database specifically with utf-8 charset to
get even things with MySQLdb to work (which I finally did). But for
anything to work, I had to do this beforehand:
cursor.execute("set collation_connection=utf8_general_ci")
cursor.execute("set collation_server=utf8_general_ci")
cursor.execute("set character_set_results=utf8")
With SA, when I try to do, say, an insert with something like:
ins = utest_t.insert({'lastname':
"hello"})
conn.execute(ins)
no matter what I do I get errors like:
sqlalchemy.exceptions.DBAPIError: (LookupError) unknown encoding:
latin1_swedish_ci
Does anyone know what I am doing wrong here? Or, how I can make things
right?
BTW, I have tried various versions of the connection string:
conn_string = "mysql://xx:[EMAIL PROTECTED]/utest?
use_unicode=1&charset=utf8"
conn_string = "mysql://xx:[EMAIL PROTECTED]/utest?
use_unicode=0&charset=utf8"
conn_string = "mysql://xx:[EMAIL PROTECTED]/utest"
but with the same results.
All I can say is, unicode on mysql is, well...... I won't say it.
Thanks!
David
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
