Re: latin1 vs UTF-8

2008-05-13 Thread Waynn Lue
I assume I should check if my mysql has support for UTF-8, I believe it just has to be 4.1 or newer. And, that's only necessary so you can get UTF-8 aware sorting and such. You don't need any special support to just _store_ UTF-8 data. Ah, that's actually the critical part. I'm

Re: latin1 vs UTF-8

2008-05-13 Thread Warren Young
Waynn Lue wrote: I'm getting a weird ^A character when I try to print it out in a textarea field. In that case, what character set does the browser think it should be using for the page? If you don't explicitly declare it, the browser has to guess, and you know what happens when you rely

RE: latin1 vs UTF-8

2008-05-13 Thread Jerry Schwartz
List Subject: Re: latin1 vs UTF-8 Waynn Lue wrote: I'm getting a weird ^A character when I try to print it out in a textarea field. In that case, what character set does the browser think it should be using for the page? If you don't explicitly declare it, the browser has to guess, and you know

Re: latin1 vs UTF-8

2008-05-12 Thread Warren Young
Waynn Lue wrote: I'm trying to figure out if the fact that the charset is set to latin1 is the reason why. It shouldn't be. The registered trademark symbol is code point 0xAE in ISO 8859-1 according to the 'pedia: http://en.wikipedia.org/wiki/ISO_8859-1 So, it would seem that your

RE: latin1 vs UTF-8

2008-05-12 Thread Jerry Schwartz
: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Waynn Lue [mailto:[EMAIL PROTECTED] Sent: Saturday, May 10, 2008 7:37 AM To: mysql@lists.mysql.com Subject: latin1 vs UTF-8 I'm trying to store the symbol (R) (that's the registered trademark

latin1 vs UTF-8

2008-05-10 Thread Waynn Lue
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.