Hi all,

(I'm using Pylons for the first time, so pls bear with me...)

I'm setting up a Pylons app with Mako + SQLAlchemy + MySQL + UTF-8
support
-- but I've had trouble finding one place with clear instructions on
how to do this,
so I've gathered pieces of info from here and there, but this, coupled
with the fact
that some instructions are outdated, and others not so clear, has left
me quite confused... :(

For now, I'll ask the following questions, in the hopes that someone
may help me:

- In "http://docs.pythonweb.org/display/pylonsdocs/
Internationalization,+Localization+and+Unicode#databases",
it says:
----
If you're using MySQL together with SQLAlchemy, see the following, as
there are some bugs in MySQLdb that you'll need to work around:

http://www.mail-archive.com/[EMAIL PROTECTED]/msg00366.html
----

Does this still apply for the latest versions of SQLAlchemy and
MySQLdb (v1.2.2) ?


- In "http://pylonshq.com/docs/0.9.5/internationalization.html";, it
says:
"[...] you need to consider both the encoding of the database and the
encoding used by the database driver."

How do I set this up for MySQL (to be used with SQLAlchemy)?


- And, BTW, which MySQL version is preferred?

I ask this, mainly because MySQLdb's changelog says:
----
  * MySQL-4.1 is supported and tested. The prepared statements API is
not
    supported, and won't be until MySQLdb-1.3 or 2.0.

  * MySQL-5.0 is supported and tested, including stored procedures.
----

So is MySQL-5.0 the best option?


Thanks in advance!

-Andy P.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To post to this group, send email to pylons-discuss@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to