OK, I admit that I am a little biased as a Java programmer. But is it too much to ask for from a major commercial database? In Storing UTF-8 Data in SQL Server, Microsoft acknowledges that "some applications (especially those that are Web based) must deal with Unicode data that is encoded with the UTF-8 encoding method". But instead of adding UTF-8 support to SQL Server, they patch up the IIS to perform UCS-2 to UTF-8 translation and of course you have to use ASP to benefit from that. As for those who dare to write their web applications in other insignificant languages such as JSP, you deserve to write your own conversion routine. And if your language of choice doesn't support UCS-2, you really should switch to any of "ODBC, OLEDB, COM, Win32 API calls, VB, and C".
Technorati Tags: developer observation