latin1 vs UTF-8
I'm trying to store the symbol (R) (that's the registered trademark symbol) in my database, but I get a weird Ctrl-A (^A) character whenever I try. At first, I thought it was because I was calling htmlentities without passing in UTF-8 as the last argument, but that only solved one of my problems. Then I spent some time looking at encodings, and I'm trying to figure out if the fact that the charset is set to latin1 is the reason why. Assuming it is, is there anything I can do to avoid having to dump the database and recreate it with the other encoding? I've spent some time tonight looking on the web and at MySQL's documentation on charsets and these are the options I've come up with. alter table TABLE_NAME convert to character set utf8; I'm assuming this is just a regular alter table, which means I'm going to have to take down my server for the duration of the change, which can take long periods of time. http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html This essentially is dump and recreate the db. iconv This was mentioned somewhere, but no one had a concrete implementation. Also, are there any gotchas in doing this? I assume I should check if my mysql has support for UTF-8, that I need to issue SET NAMES 'utf8'; or put it into my.cnf, and that my php code needs to output the headers with UTF-8 as well. Thanks, Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help needed
Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. It will display an ID, please mail me back the ID. If you can use it on several computers, it will be even better for me, I need to have as much results as possible. The program i'm testing is supposed to create a unique ID for each PC, this is why I need to test if it is really unique. This file is virus free and cannot do any harm to your PC. It is however a voluntary testing. Thanks for your help in advance. Velen
Re: Table Locking (Was: Best CPU config for a busy DB server)
Table locking will occur with MyISAM tables when any row(s) of the table is being updated (Update,Delete,Insert,Load Data etc). If you are only executing Select statements, then they can be executed in parallel and won't be blocked. Just curious: you say with MyISAM tables - do any of the other table types (InnoDB, Falcon, etc) behave differently? Thanks, JW -- -- System Administrator - Cedar Creek Software http://www.cedarcreeksoftware.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table Locking (Was: Best CPU config for a busy DB server)
On Sat, May 10, 2008 at 4:24 PM, JW [EMAIL PROTECTED] wrote: Table locking will occur with MyISAM tables when any row(s) of the table is being updated (Update,Delete,Insert,Load Data etc). If you are only executing Select statements, then they can be executed in parallel and won't be blocked. Just curious: you say with MyISAM tables - do any of the other table types (InnoDB, Falcon, etc) behave differently? Thanks, JW When locks are necessary, InnoDB uses row-level locking. MySQL 5.0 Certification Study Guide, page 419 -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]