Hi all, I am in the process of Internationalizing our website. I am aware that I may well have to make changes to the database with regards to collation. I need to know which is the best catch all collation type or am I going to have bigger problems?
The main languages that we are going to use i.e. English, French, Spanish, etc all work ok with the default collation on the appropriate text column. I start to have problems when I try to store Hindi characters. When I look at the database after storing the Hindi text or try to display it onlt show loads of question marks as follows '??? ???? ??'. Any idea what I need to do to fix this? Am I going to have to create different columns with different collations?
Any advice greatly appreciated.