locked
Asking about C# 2012 using local databases. RRS feed

  • Question

  • i m developing program using C# 2010 using local database, when i insert data which language is Amharic, it display '?' and also when it retrieve it to datagridview it also display the same way. what i should do?
    • Moved by Vicky SongMicrosoft employee Friday, January 4, 2013 2:33 AM (From:Visual Studio Database Development Tools (Formerly "Database Edition Forum"))
    Monday, December 31, 2012 7:33 AM

Answers

  • i m developing program using C# 2010 using local database, when i insert data which language is Amharic, it display '?' and also when it retrieve it to datagridview it also display the same way. what i should do?

    as you're using C# you're already on the right side with the client as you're using unicode character set for strings.

    On the database side, how did you declare the columns containing the incorrect text ?

    did you declare them as varchar() ?

    you should use nvarchar() to specify unicode character set to store the data in the database.


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Proposed as answer by Bob Shen Monday, January 7, 2013 7:07 AM
    • Marked as answer by Bob Shen Tuesday, January 8, 2013 3:31 AM
    Tuesday, January 1, 2013 5:45 PM

All replies

  • Hi tsionabebe,

    Thanks for your post. However, I am sorry that here is not the correct forum for you to deal with your question. The forum here is mainly about developing database projects in VS. What kind of project you are working with? I would like to help you to move it to the correct forum so that you can get better response.

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, January 1, 2013 2:25 AM
  • i m developing program using C# 2010 using local database, when i insert data which language is Amharic, it display '?' and also when it retrieve it to datagridview it also display the same way. what i should do?

    as you're using C# you're already on the right side with the client as you're using unicode character set for strings.

    On the database side, how did you declare the columns containing the incorrect text ?

    did you declare them as varchar() ?

    you should use nvarchar() to specify unicode character set to store the data in the database.


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Proposed as answer by Bob Shen Monday, January 7, 2013 7:07 AM
    • Marked as answer by Bob Shen Tuesday, January 8, 2013 3:31 AM
    Tuesday, January 1, 2013 5:45 PM
  • Hi tsionabebe,

    I am moving your issue to the C# related forum so that you can get better support there.

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, January 4, 2013 2:31 AM