[sqlalchemy] Re: turbogears, sqlalchemy and utf8

2007-10-23 Thread Marco Mariani

Lukasz Szybalski wrote:

 dev.cfg has

 sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname
   

sqlalchemy.convert_unicode = True


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



[sqlalchemy] Re: turbogears, sqlalchemy and utf8

2007-10-23 Thread Lukasz Szybalski

On 10/23/07, Marco Mariani [EMAIL PROTECTED] wrote:

 Lukasz Szybalski wrote:

  dev.cfg has
 
  sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname
 

I did this in dev.cfg :

 sqlalchemy.convert_unicode = True
sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname

now I get a different error?

 File /usr/lib/python2.4/site-packages/sqlalchemy/types.py, line 174, in con
vert_result_value
return value.decode(dialect.encoding)
AttributeError: 'array.array' object has no attribute 'decode'

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



[sqlalchemy] Re: turbogears, sqlalchemy and utf8

2007-10-23 Thread jason kirtland

Lukasz Szybalski wrote:
 On 10/23/07, Marco Mariani [EMAIL PROTECTED] wrote:
 Lukasz Szybalski wrote:

 dev.cfg has

 sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname

 I did this in dev.cfg :
 
  sqlalchemy.convert_unicode = True
 sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname
 
 now I get a different error?
 
  File /usr/lib/python2.4/site-packages/sqlalchemy/types.py, line 174, in con
 vert_result_value
 return value.decode(dialect.encoding)
 AttributeError: 'array.array' object has no attribute 'decode'

I'd guess the mysql-python DB-API installed on your system is an alpha 
or beta version?  Try upgrading to 1.2.2 or 1.2.1 if so.

Also, very few MySQL installations have unicode-safe connection 
encodings configured by default, so it's a very good idea to include the 
'charset=utf8convert_unicode=0' in the database URL to avoid data 
corruption and encoding exceptions.


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