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
mg>hopefully 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

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 w

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 w

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 Date: Sun, 7 Jun 2009 22:52:22 To: Uma Bhat Cc: ewen fortune; Subject: Re: Best way to conv