Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-07 Thread Petr Jakeš
> >   fromDatabase machinery for MySQL takes into account parameters from DB > URI - 'use_unicode' and 'charset'. If use_unicode is set to True (1) > columnsFromSchema() replaces all StringCol by UnicodeCol with charset as > its dbEncoding. > Thanks. This works great.

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-07 Thread Oleg Broytman
On Thu, Feb 04, 2010 at 10:15:27PM +0100, Petr Jake?? wrote: > > There is no currently. What do you want? To define an encoding for all > > UnicodeCol'umns at once? > > > Yes, that was the main idea. When I am working with existing database, I do > not declare columns manually (I am using fromDat

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-05 Thread Oleg Broytman
On Fri, Feb 05, 2010 at 11:49:05AM +0100, Petr Jake?? wrote: > Hmmm... when the connection is set as: > connection = connectionForURI("mysql:// > prestashop:prestas...@127.0.0.1:3306/prestashop?use_unicode=1&charset=utf8") > > the encoding setting for each column is not necessary. Perhaps beca

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-05 Thread Petr Jakeš
> Well, I added the idea to my TODO. > > Hmmm... when the connection is set as: connection = connectionForURI("mysql:// prestashop:prestas...@127.0.0.1:3306/prestashop?use_unicode=1&charset=utf8") the encoding setting for each column is not necessary.

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-05 Thread Oleg Broytman
On Thu, Feb 04, 2010 at 10:15:27PM +0100, Petr Jake?? wrote: > > To define an encoding for all > > UnicodeCol'umns at once? > > > Yes, that was the main idea. When I am working with existing database, I do > not declare columns manually (I am using fromDatabase = True). Well, I added the idea

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-04 Thread Petr Jakeš
> There is no currently. What do you want? To define an encoding for all > UnicodeCol'umns at once? > > Yes, that was the main idea. When I am working with existing database, I do not declare columns manually (I am using fromDatabase = True). But I can define encoding for each row manually of co

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-04 Thread Oleg Broytman
On Thu, Feb 04, 2010 at 09:46:16PM +0100, Petr Jake?? wrote: > I would like to know, if it is possible to > set the encoding for the whole table at once (or for the > connection/database) instead to define it for each column. There is no currently. What do you want? To define an encoding for al