#41533 [Bgs]: function dbase_get_record_with_names doesnt read special characters

ID: 41533 User updated by: jprolando at gmail dot com Reported By: jprolando at gmail dot com Status: Bogus Bug Type: dBase related Operating System: Windows XP PHP Version: 5.2.3RC1 New Comment: I understand you what you said, but the function you did to me not solve my problem. We are migrating from DBF to MySql, so the problem. Is there another way to solve it, without leaving DBF, with PHP? It seems to me your function is not an universal one... It doesn't work properly everytime, everyway I appreciate your time, thank you very much. Previous Comments: ------------------------------------------------------------------------ [2007-05-30 14:28:33] tony2001@php.net I get the very same result using dbview, hence it doesn't seem to be PHP problem. You should not be using DBF anyway, there are plenty of real databases. ------------------------------------------------------------------------ [2007-05-30 13:57:13] jprolando at gmail dot com 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 ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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