phpmyadmin utf8

[Isset1988]

Hello, i have this script to update my database.

 

<?php
include("connector.php");

mysql_select_db("Table", $con); 


$sql = "UPDATE Persons SET FirstName='something not on english character' WHERE FirstName='test' AND LastName='test2'";

mysql_query($sql);


// Close connection
mysql_close($con);
?>

 

I have a utf8_general_ci database and i create a table with uft8 columns

 

<?php
include("connector.php");

// Sql query
mysql_select_db("Table", $con);
$sql = "CREATE TABLE Persons
(
Id int NOT NULL AUTO_INCREMENT,
FirstName varchar(15) NOT NULL,
LastName varchar(15) NOT NULL,
PRIMARY KEY (Id)
)CHARSET=UTF8";

// Execute query
mysql_query($sql,$con);

// Close connection
mysql_close($con);
?>

 

When i try see the includes of columns in phpmyadmin, i see these symbols ????????.

I know that is not a problem, because when i select and print my table on a utf8 charset php page, everything shows nice.

 

Is there any way to see columns on utf8 when i access to phpmyadmin?

 

 

Thank u!

[jazzman1]

Try in this wasy:

 

<?php
include("connector.php");

mysql_select_db("Table", $con); 

$sql = "UPDATE Persons SET FirstName='something not on english character' WHERE FirstName='test' AND LastName='test2'";

mysql_query('SET NAMES UTF8');

mysql_query($sql);

// Close connection
mysql_close($con);

?>

[Isset1988]

Thank u! Thank u!     

 

Question Solved