Thread safe queries with multiple connections

2009-06-07 Thread buford
I think my question is whether the data in MYSQL_RES and MYSQL_ROW data structures are sufficiently independent from that of other instances of those data structures in a multi-threaded situation when a pool of connections are share. The application my have multiple connections structures defined

RE: Thread safe queries with multiple connections

2009-06-07 Thread Martin Gainty
mghopefully quick comments Date: Sun, 7 Jun 2009 04:41:20 -0600 Subject: Thread safe queries with multiple connections From: buf...@biffco.net To: mysql@lists.mysql.com I think my question is whether the data in MYSQL_RES and MYSQL_ROW data structures are sufficiently independent from

Re: Best way to convert character set from latin1 to utf8 for existing database?

2009-06-07 Thread Uma Bhat
Thank was great piece of info Ewen, Thanks! However this approach works for new data. But the existing data in the database does not show us the Japanese characters from application side. Appreciate responses who 'actually' got to work on this conversion. Thanks! Uma On 6/1/09, ewen fortune

Re: Best way to convert character set from latin1 to utf8 for existing database?

2009-06-07 Thread Darryle Steplight
Uma, I apologize in advance if this is redundant ,because I did not click on any of Ewen's link. Nonetheless, this is the approach I would take. start your mysql server with different --character-set-server and ---collation-server options Type SHOW COLLATION; in your mysql shell to determine

Re: Best way to convert character set from latin1 to utf8 for existing database?

2009-06-07 Thread Chaim Rieger
Export schema Export data Change exported schema to utf8 Import schema into new db Import exported data into new db Sent via BlackBerry from T-Mobile -Original Message- From: Darryle Steplight dstepli...@gmail.com Date: Sun, 7 Jun 2009 22:52:22 To: Uma Bhatbhat@gmail.com Cc: ewen