How To Greate Full Multi Languages Script


In my script I need to create full multi language content and texts

for example :

English/index.php?r=site/articles :

will load all English Articles from database

Turkish/index.php?r=site/articles :

will load all Turkish Articles from database

for Example I will add to my database language column and will have value :



What is the best solutions in YII to do that

Thank you .