How to save "F" this symbol in database using c#

Question

Hai I want to save this symbol Φ in database table . I used to save this symbol asusual in backend but it was save f like this . I want to save Φ this symbol and as well as retrieve this symbol. What query I have to use for save this symbol. Anybody help this question. Thanks in advance.

Raja T · Answer

Hi Pavithra If You can use some special symbol combination like '%@^@%' instead of your symbol 'Φ' for save the data into table. Now save the data into database. Then retrieve data from database check given symbol is '%@^@%' available at the time you can replace your symbol Φ.

Pavithra L · Answer

Hai Manas Am tried your datatype but it was save like fonly  it was not save that symbol . How can I save that symbol in database. am using .mdf database in this project.

Manas Mohapatra · Answer

I am assuming that you are using SQLServer. You need to Unicode datatype for that column. Make the column datatype as nvarchar (1000) and store the value.