Answered by:
Asking about C# 2012 using local databases.

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.
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.
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