views:

188

answers:

1

I have a basic web form in asp.net for recording some basic information.

How do I ensure that I can accept information in any language, store in sql and then redisplay on another webpage correctly. At the moment accents on certain characheters are displaying incorrectly.

+2  A: 

Make sure your field data type in the SQL DB is Nvarchar, Nvarchar support unicode
Check for SQL Datatype Details..

http://msdn.microsoft.com/en-us/library/ms186939.aspx http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqlr.doc/sqlrmst126.htm

Muhammad Akhtar
Yes NVARCHAR supports multibyte characters
Mark Redman