ID: 41533
Updated by: [EMAIL PROTECTED]
Reported By: jprolando at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: dBase related
Operating System: Windows XP
PHP Version: 5.2.3RC1
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
Are you sure the database really contains those characters (and not the
broken ones)? Did you check it? How?
------------------------------------------------------------------------
[2007-05-29 21:38:22] jprolando at gmail dot com
Description:
------------
Excuse me for my english
I get data from a dbase database and special characters like ñ or ì are
changed by the function "dbase_get_record_with_names".
Ive tried to use Code Headers function UTF8_encode UTF8_decode and that
doesnt seem to solve the problem.
Reproduce code:
---------------
<?php
//header('Content-Type: text/html; charset=iso-8859-1');
include ('config.php');
$link = conectar_BD();
$db = dbase_open('ART1.DBF', 0);
if ($db) {
$numero_registros = dbase_numrecords($db);
for ($i = 1; $i <= $numero_registros; $i++) {
$row = dbase_get_record_with_names($db, $i);
$codigoweb1 = $row['CODIGOWEB1'];
$codigoweb2 = $row['CODIGOWEB2'];
$codigo = $row['CODIGO'];
$articulo = $row['ARTICULO'];
echo "Linea ($i):--> " . $row['ARTICULO'] . "</br>";
}
}
?>
Expected result:
----------------
The Function should display the "ñ" and "ì" characters correctly in my
web browser
Actual result:
--------------
"ñ" displays as "¤" and "ò" as "¢"
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41533&edit=1
