Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-07 Thread Anirudh Zala
On Thursday 06 May 2010 21:16:03 David Mintz wrote: > I don't really have a good understanding of issues around character sets, > encoding, what have you, though I am starting to work on it. > > My problem involves a MySQL database and accented characters such as those > you find in Spanish and Fr

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-07 Thread tedd
At 1:56 PM -0400 5/6/10, Edward Potter wrote: I highly recommend u scale up from Dreamweaver, and use an editor, TextMate is probably the best, but zillions out there. Yes I know it works fine, but you will never move to Guru status with DW. Just my 2 rupee's. The leap is pretty painless.

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread David Mintz
On Thu, May 6, 2010 at 12:59 PM, Chris Snyder wrote: > On Thu, May 6, 2010 at 12:26 PM, Anthony Wlodarski > wrote: > > I second, full UTF-8 is awesome down the line for internationalization. > > First see if MySQL even supports UTF-8 on your system, execute: "SHOW > > CHARACTER SET;" and utf8 s

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Edward Potter
woops sorry that's ed. precursor to vi. http://en.wikipedia.org/wiki/Vi On Thu, May 6, 2010 at 1:56 PM, Edward Potter wrote: > I highly recommend u scale up from Dreamweaver, and use an editor, TextMate > is probably the best, but zillions out there. Yes I know it works fine, but > you will ne

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Edward Potter
I highly recommend u scale up from Dreamweaver, and use an editor, TextMate is probably the best, but zillions out there. Yes I know it works fine, but you will never move to Guru status with DW. Just my 2 rupee's. The leap is pretty painless. Grasshopper! => Guru => God => Grasshopper! Dreamweav

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Chris Snyder
On Thu, May 6, 2010 at 1:26 PM, Paul A Houle wrote: >   There's also the issue that there really is no "Unicode Sort Order" that > entirely makes sense.  For instance,  languages such as German and Swedish > sort the same characters in a different order.  I'm currently working on a > system that

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Paul A Houle
Chris Snyder wrote: Dirty secret - MySQL latin-1 tables will happily store and retrieve utf-8 data. They won't sort it correctly, though I believe they will sort it consistently. So even if your MySQL was compiled without unicode support, you can put utf-8 in and get utf-8 out. Of course, if yo

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Mona Borham
Well sometimes also you should changes the page encoding to UTF-8 which I can't modify as I know except through DreamWeaver and I wanted to know if there is a shortcut for this process rather than opening all the project files and modify the page properties. If anyone has idea please provide us wit

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Chris Snyder
On Thu, May 6, 2010 at 12:26 PM, Anthony Wlodarski wrote: > I second, full UTF-8 is awesome down the line for internationalization. >  First see if MySQL even supports UTF-8 on your system, execute: "SHOW > CHARACTER SET;" and utf8 should appear in the list.  Then "ALTER TABLE > tbl_name CONVERT T

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Anthony Wlodarski
: NYPHP Talk Sent: Thu, May 6, 2010 11:56:09 AM Subject: Re: [nyphp-talk] utf-8, iso-8859-1... On Thu, May 6, 2010 at 11:46 AM, David Mintz wrote: > Would this regex work if the data were utf-8? Should I consider converting > everything and working in utf-8, and if so, how painful is

Re: [nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread Chris Snyder
On Thu, May 6, 2010 at 11:46 AM, David Mintz wrote: > Would this regex work if the data were utf-8? Should I consider converting > everything and working in utf-8, and if so, how painful is it to convert a > MySQL database? My initial research suggests that it isn't painless. > Full-stack utf-8

[nyphp-talk] utf-8, iso-8859-1...

2010-05-06 Thread David Mintz
I don't really have a good understanding of issues around character sets, encoding, what have you, though I am starting to work on it. My problem involves a MySQL database and accented characters such as those you find in Spanish and French. My web server sends a "content-type: text/html; charset=