Digital Pimp
07-15-2009, 11:06 AM
Hi
I have a site that sells products to customers in the UK & abroad. The site is built in ASP and MS SQL 2005. The problem is when customers abroad purchase and fill in the delivery address form the database results show any special characters (i.e. ä ŝ æ ë - particularly Norwegian, German, French) as random characters rendering the adresses unreadable.
My question is is there a way at any level of converting those characters to make the addresses in the database readable? Is it that MS SQL 2005 doesn't support Unicode?
TIA
I have a site that sells products to customers in the UK & abroad. The site is built in ASP and MS SQL 2005. The problem is when customers abroad purchase and fill in the delivery address form the database results show any special characters (i.e. ä ŝ æ ë - particularly Norwegian, German, French) as random characters rendering the adresses unreadable.
My question is is there a way at any level of converting those characters to make the addresses in the database readable? Is it that MS SQL 2005 doesn't support Unicode?
TIA