i am working on db design of multilingual site. For creating multilingual site we usually use xml or different col in table represting language. I am thinking of using diferernt db for each languge,it will simplifies many things. so my question is that, is this thing of using muliple database for mulitple lanuage is good or bad one
It's a bad idea because you will be duplicating data structures. In development you will have to replicate any database design change in all databases.
It's much easier to develop in only one language and to add translations either by means of additional content fields or by means of one big translation table with all interface strings and their respective translations.