Hi People.....
I need import some data from a Paradox table, i used the script below, it worked just
fine......but all the data was imported without the " � or � or � ", understand???
portuguese words.... all this changes to some wierd caracter.... is there a way to fix
this, since my table is a Paradox 4 ANSI INTL850..... am i fried??????
<?
$conexao = odbc_connect("rodrigo","","") or die();
$query = odbc_exec($conexao,"Select * from clientes") or die();
include("link_db_pratic.php");
$delete = mysql_query("delete from cli");
while (odbc_fetch_row($query)) {
$clirep = odbc_result($query,1);
$clicod = odbc_result($query,2);
$cliemp = odbc_result($query,3);
$clinom = odbc_result($query,4);
$cliend = odbc_result($query,5);
$clitel = odbc_result($query,6);
$clifax = odbc_result($query,8);
$cliema = odbc_result($query,9);
$clibai = odbc_result($query,10);
$clicid = odbc_result($query,11);
$cliest = odbc_result($query,12);
$clicep = odbc_result($query,13);
$cliins = odbc_result($query,14);
$clifat = odbc_result($query,17);
$clicgc = odbc_result($query,19);
$clicta = odbc_result($query,21);
$clilic = odbc_result($query,22);
$clidia = odbc_result($query,25);
echo"$clirep<br>";
echo"$clicod<br>";
$insert = mysql_query("INSERT INTO cli (clirep, clicod, cliemp, clinom, cliend,
clitel, clifax, cliema, clibai, clicid, cliest, clicep, cliins,clifat, clicgc, clicta,
clilic, clidia) VALUES('$clirep', '$clicod', '$cliemp', '$clinom', '$cliend',
'$clitel', '$clifax', '$cliema', '$clibai', '$clicid', '$cliest', '$clicep',
'$cliins', '$clifat', '$clicgc', '$clicta', '$clilic', '$clidia');");
}
?>
--------------------------------------------------------------------------------
Equipe Pratic Sistemas
Rodrigo Corr�a
Fone: (14) 441-1700
[EMAIL PROTECTED]
[EMAIL PROTECTED]