Click here to Skip to main content
15,938,848 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
>how to insert a unicode character such as amharic in sql server db from web application form
nvarchar data types accepts the value back end but not from the app. All I need is to read the values from the form and insert into the db table. It changes the unicode values such as Amharic alphabets to '???'

What I have tried:

I used nvarchar(max) data type for the field and it accepts the unicode values when inserted manually back end
Updated 30-Aug-22 8:04am
Richard MacCutchan 30-Aug-22 6:52am    
The database will not change any characters that you enter. The problem will be when you try to display them without using the correct font.
Gizachew Eshete 30-Aug-22 7:01am    
how am I gonna do that? I input the chars on the form correctly but when I go back ende and see the values they are like "?????" as many as the number of the chars
Richard MacCutchan 30-Aug-22 7:13am    
Because the form will use the default font, which most likely does not include Amharic characters. See amharic font windows forms c - Google Search[^].

1 solution

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900