Special character sets in Website

alwinSCH

Hi, I have a website with some inputboxes! (the site is multi-language! French-Dutch-English) Now i want to add an address in my site wich is stored in SQL-server but the address is in Slovakia ... poisťovňa when pressing insert it gives me --> poisovòa on my listview when i try to remake this on my test site it is all correct! The special characters in SQL are stored like AsCII code and in my listview on my website it is displayed perfect! --> So when i insert manually the perfect ascii code in SQL it is displayed also perfect on my production site! - Is it some problems with code page? on the webserver (W2003) - has it something to do with sql? - Regional settings on webserver - ASP.NET settings? - IIS settings? - other problem? I do not know where to look anymore! I cannot see a difference between settings on code page, IIS settings, SQL between test and production! Or i must over look something! Kind Regards, A.

Lost User

Try following links... Working with Languages in the User Interface http://msdn.microsoft.com/en-us/library/ms142796.aspx[^] International Considerations for Databases and Database Engine Applications http://msdn.microsoft.com/en-us/library/ms190245.aspx[^] You will surely find solution. HTH

Jinal Desai - LIVE Experience is mother of sage....

alwinSCH

Yes thank you, i found a solution! It is more a SQL problem! than something with web-development! Only it is not that easy anymore to change our collation of SQL-server because DB is standing in Correct collation mode... But hey, we will find something! thanks!