language problem RRS feed

  • Question

  • User-806613855 posted
    I am  beginner in asp.net & have a problem..
    when enter utf-8 code (farsi language) in club site (web developer template) show me ???????????
    pleas help me to solve this.....
    Friday, June 16, 2006 4:38 AM

All replies

  • User1472830812 posted


    Can you please be more specific in your problem, then i can try to get a solution for ur problem


    Friday, June 16, 2006 6:22 AM
  • User-806613855 posted

    I type word by farsi language(utf-8) in news or album name or location & events but when load

    the page show me this  ?????????

    Saturday, June 17, 2006 5:12 PM
  • 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') موفقیت خوب


    Saturday, June 17, 2006 11:06 PM