User654902800 posted
Hi afshin,
the problem is the way the database was designed - the colums that store character data are not compatible with utf-8. What you need to do is to open each table definition that is going to store utf-8, and change the
varchar and text colums to nvarchar and ntext.
For example, in the table Announcements, you want
[title] [nvarchar] (500) NOT NULL ,
[description] [nvarchar] (2000) NULL ,
[staticURL] [nvarchar] (500) NULL ,
There are a few stored procedures that declare variables also, that you may want to change to n*
Personally, it is my opinion that when designing databases that *might* contain input from
people, that you should plan in advance to handle utf-8. It's a shame the starter kit didn't do that, but it's not too hard to fix.
Cheers and (hopefully this comes out as 'good luck') موفقیت خوب
