#41533 [Fbk->Opn]: function dbase_get_record_with_names doesnt read special characters

From: Date: Wed, 30 May 2007 13:57:14 +0000
Subject: #41533 [Fbk->Opn]: function dbase_get_record_with_names doesnt read special characters
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-113198@lists.php.net to get a copy of this message
ID: 41533 User updated by: jprolando at gmail dot com Reported By: jprolando at gmail dot com -Status: Feedback +Status: Open Bug Type: dBase related Operating System: Windows XP PHP Version: 5.2.3RC1 New Comment: Script is the following one: <?php header('Content-Type: text/html; charset=iso-8859-1'); $db = dbase_open('ARTD.DBF', 0); if ($db) { $numero_registros = dbase_numrecords($db); for ($i = 1; $i <= $numero_registros; $i++) { $row = dbase_get_record_with_names($db, $i); $articulo = $row['DETALLE5']; echo "Linea ($i):--> " . $row['DETALLE5'] . "</br>"; } } ?> you can get the database in the following adress: http://www.hartley.edu.uy/ARTD.DBF thanks Previous Comments: ------------------------------------------------------------------------ [2007-05-30 13:25:50] tony2001@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2007-05-30 13:15:13] jprolando at gmail dot com Those Characters are iso-8859-1 they are characters that are used in spanish. Also when i load dbase database on MS-DOS they also display correctly. Ive tried using this <?php header('Content-Type: text/html; charset=iso-8859-1'); ... and using that charset it should work fine. ------------------------------------------------------------------------ [2007-05-30 13:05:39] tony2001@php.net Ok, so what are these characters? Some unicode ones? Then I guess you need to set appropriate encoding of the page to see them. ------------------------------------------------------------------------ [2007-05-30 12:59:10] jprolando at gmail dot com Well, the database is being used in my bussines, and Im sure those characters are displayed correctly. Besides I load the database on acces and the special characters show up correctly. Here is a screenshots of the database being used in access http://www.hartley.edu.uy/caracteresacces.bmp ------------------------------------------------------------------------ [2007-05-29 21:41:28] tony2001@php.net Are you sure the database really contains those characters (and not the broken ones)? Did you check it? How? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/41533 -- Edit this bug report at http://bugs.php.net/?id=41533&edit=1

« previous php.bugs (#113198) next »