No I'm not concerned with the extra byte per character. I just wanted to make sure there was no way to set a column to be UTF-8 before I went...

Thanks. Does nvarchar really support UTF-8, or is it just for UCS2? It was my understanding that nvarchar was a two-byte/character column type that stored all its text data in...

Thanks. I should have worded that question differently. The full question was "does SQL Server 2005 fully support UTF-8?" By "fully support" I mean that all of its string functions...