Dear Oleg, thank you very much. regarding encoding in mysql you can set different character set for each column in a table you can get information about character set by the SHOW FULL COLUMNS FROM <table> command here the 3rd field is the collation, which refers to the charset as well
SHOW CREATE TABLE <table> also displays information regarding table character set. http://dev.mysql.com/doc/refman/5.0/en/charset-show.html Thursday, June 15, 2006, 6:45:52 PM, you wrote: OB> On Thu, Jun 15, 2006 at 01:03:22PM +0200, Ivan Horvath wrote: >> but as i figured out i only had to modify mysqlconnection.py >> according to my test it works well. >> i stored an xls file in a BLOB field, while i write some >> Hungarian text in a TEXT field. OB> I applied the patch. I also set encoding for UnicodeCol from OB> self.client_encoding; I am not sure it's the right solution, but where to OB> get the DB encoding from? OB> I committed the patch in the revision 1814. OB> Oleg. -- Best regards, Ivan Horvath Chief Programmer Alcatel ISD PMS 2000 Product Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209 9546 Fax.: +36 1 209 9599 Mobil: +36 30 257 0235 VOIP: +49 511 676 478010 mailto:[EMAIL PROTECTED] Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss