inserting special characters in MySQL database

[ebookz]

how to insert alpha,beta,delta to mysql database through php script?????
I want save my subject codes to my db table using these special characters..
example subject code "CSC113α"

can any one plzz help to do this....thanks in advanced....

[abduraooft]

You'd need to change the collation of that filed to utf8_general_ci. Then add the following line to your PHP code before all insert/fetch operation to the DB - better to be used under mysql_select_db() statement.

PHP Code:

mysql_query("set names 'utf8'");