The search returns 2 entries and I don't see the location on either. In any event, if your mysql database can be accessed independent of the web page and php, and is correctly encoded as 8859-1 or more correctly as 1252, then somewhere between the db and the web server an encoding conversion is being applied to change the data to utf-8.
Since php is in between, verify the encoding of the data that is retrieved by php. If it is still 1252, then verify that php is sending data to the server as 1252 (directly from php as well as data from the database). If you have any utilities that munge the data anywhere along the way, verify those also. hth Tex Texin Internationalization Architect, Yahoo! Inc. -----Original Message----- From: steve [mailto:[EMAIL PROTECTED] Sent: Monday, November 22, 2004 2:40 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-I18N] Accented characters Tex Texin wrote: > Steve, > The page looks to me to be a mix of encodings. > There is a euro character and an e-acute which are windows-1252. (The > euro is not in iso 8859-1, although many fonts will behave as if > 8859-1 was 1252, so it looks ok.) > > Then there are characters in front of the telephone numbers: "Ti??:" I > am not sure what was intended. I suspect somewhere along the way an > incorrect encoding conversion was performed. If it is coming from your > database, it may have been corrupted before it was stored. If you are > lucky the data in the database is ok, and the incorrect conversion is > being performed between the retrieval of the data and the inclusion in > the web page. Yeah, sorry Tex - when I included that URL I should have given some more info. That's obviously the old version of the site, when I was even lower down the learning curve(!). Some of those dodgy characters have arisen because I simply typed the accented characters from the keyboard into the PHP code, rather than using HTML entities like é. I started creating the site on a Windows box and moved to a Linux one... The bit that concerns me is this: on the page www.webvivant.com/market/, if you enter the word 'partner' into the search box and hit 'search now...' it should bring up just one message. At the end of that message is the person's location, which is the Midi-Pyrénées. That text is pulled from the MySQL table. The accented characters work fine on the live system when the page is delivered/viewed as iso-8859-1. On my local system, the page needs to be delivered/viewed as utf-8. -- @+ Steve -- PHP Internationalization Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Internationalization Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
