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
Are you using mysqli, PDO, or mysql? There are differences in the way the character set is determined, as I discovered after much the same experience as yours. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: