greek characters issue

Question

User1386200375 posted

How can I support greek characters in my .net application with sql server as the database, when I enter greek character in my application they  appear right but when Ic lck submit and they go to database and gets displayed incorrectly...does it mean that my database is not acccepting greek characters or I should give a code in my .net application?

Answer 1

User-1360095595 posted

Try using nvarchar for your DB column. 

Answer 2

User1386200375 posted

for which column? I have about 70 tables in my database with 10-12 columns each......they all are being used in my application????

Answer 3

User-1360095595 posted

Do a test with  one colulmn to make sure it works.  Then you need to do it to all columns that are varchar.  And if they're char, you'll need to use nchar.  Good luck. 

Answer 4

User1386200375 posted

I tried doing it to a column of nvarchar but it dint work what do i do now?

Answer 5

User-1360095595 posted

Maybe look at collation.

Refer: http://msdn.microsoft.com/en-us/library/ms184391.aspx 

Answer 6

User1386200375 posted

how do i do that? and what could be the error?

Answer 7

User1386200375 posted

can someone plzzzzzzzzzzzzzzzzzzzzzz help mewith this issue its urgent I rely need to find a way for this plzzzzzzzzzzz

Answer 8

User-1200560727 posted

Hi Tanya,

Your database type should nVarchar or nText.

Please go through my below posts:

http://forums.asp.net/t/1553233.aspx

http://forums.asp.net/p/1514920/3621670.aspx

http://forums.asp.net/t/1544401.aspx

Please let me know if you still facing the same problem.

Regards,

Tapan

Answer 9

User-1200560727 posted

This issue has been resolved: http://forums.asp.net/t/1561722.aspx