How do I create a MySQL table that contains various collations? 1

[lupidol]

Hi everyone,
This is a code to create a MySQL table:

$dbcon = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) ;
$q = 
"CREATE TABLE list 
(
fname VARCHAR(30) NOT NULL,
email VARCHAR(60) NOT NULL,
PRIMARY KEY (fname)
)";
$result = @mysqli_query ($dbcon, $q);

The above table doesn't suit my needs because my "fname" input is of non latin characters ! I get
"fname" values such as '????'.
I read about "utf8_general_ci" but this addresses to the whole table and i need only one field of that collation
to be "utf8_general_ci" .
Can someone please write here a code that creates a "multi collations" table?
Thanks

 

[ChrisHirst]

http://dev.mysql.com/doc/refman/5.0/en/charset-column.html

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[lupidol]

Thanks a lot !