<![CDATA[Latest posts for the topic "Codification issues"]]> http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net Codification issues I was thinking it was something to do with php, but phpmyadmin shows it properly with full special chars support. But in my script i can't make it work. I tried all strings functions, all things about strings convertion, but nothing through. Anybody could help me? ]]> http://forum.geonames.org/gforum/posts/list/142.page#713 http://forum.geonames.org/gforum/posts/list/142.page#713 GMT Re:Codification issues http://forum.geonames.org/gforum/posts/list/142.page#714 http://forum.geonames.org/gforum/posts/list/142.page#714 GMT Re:Codification issues http://forum.geonames.org/gforum/posts/list/142.page#715 http://forum.geonames.org/gforum/posts/list/142.page#715 GMT Re:Codification issues http://forum.geonames.org/gforum/posts/list/142.page#716 http://forum.geonames.org/gforum/posts/list/142.page#716 GMT Re:Codification issues http://forum.geonames.org/gforum/posts/list/142.page#717 http://forum.geonames.org/gforum/posts/list/142.page#717 GMT Re:Codification issues http://forum.geonames.org/gforum/posts/list/142.page#719 http://forum.geonames.org/gforum/posts/list/142.page#719 GMT Re:Codification issues which is fine, but same configuration, and with all utf8 treatments i got this Doing the same query, same php and apache configuration and same browser config That is what i mean]]> http://forum.geonames.org/gforum/posts/list/142.page#721 http://forum.geonames.org/gforum/posts/list/142.page#721 GMT Re:Codification issues Code:
 echo "<html><head></head><body>";
$res = mysql_query("select a row from the table");
while ($row = mysql_fetch_object($res)){ echo $row->name . "<br />";}
echo "</body></html>";
with charset and doctype of course?]]> http://forum.geonames.org/gforum/posts/list/142.page#722 http://forum.geonames.org/gforum/posts/list/142.page#722 GMT Re:Codification issues Code:

<html>
   <head>
       <meta http-equiv=Content-Type content="text/html; charset=utf-8" />

<?
     	$link = mysql_connect ("localhost", "$usert", "$pass")
        	or die ("no me puedo conectar al servidor: " .mysql_error());

    	mysql_select_db("edr") or die("No puedo seleccionar la base de datos");


       	$query = "Select name FROM `geonames` WHERE `country_code` LIKE 'VN' GROUP BY name LIMIT 0 , 30 ";
  	$result = mysql_query($query) or die("No puedo realizar la consulta");


      echo "<table>";
      while($row=mysql_fetch_array($result)){

          echo "<tr><td>".$row[name]."</td></tr>";
      }
      echo "<table>";
mysql_close($link);

?>
Thank you very much indeed for your attention]]> http://forum.geonames.org/gforum/posts/list/142.page#723 http://forum.geonames.org/gforum/posts/list/142.page#723 GMT Re:Codification issues Code:
header('Content-Type: text/html; charset=utf-8');
as the first line of anything else in PHP. If this not helps, I have no more ideas, except install everything again :( Lo siento mucho.]]> http://forum.geonames.org/gforum/posts/list/142.page#724 http://forum.geonames.org/gforum/posts/list/142.page#724 GMT Re:Codification issues <- Code:

        $link = mysql_connect ($server, $user, $pwd) or die ("No puedo conectar a la base de datos: " .mysql_error());

        mysql_select_db($datenbank) or die("No puedo seleccionar la base de datos");
        ---> @mysql_query("SET NAMES 'utf8'"); <----
That was what i had missing in my code and phpmyadmin did have. I hope it help someone else. Cheers]]> http://forum.geonames.org/gforum/posts/list/142.page#774 http://forum.geonames.org/gforum/posts/list/142.page#774 GMT