MySql problem..............

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
        suporte@praticsistemas.com.br
        rodrigo@praticsistemas.com.br 
     



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux