Microsoft SQL Server uses the nchar, nvarchar, and ntext data types for UCS-2. However the JDBC specification only provides a mapping for char based data types, none for nchar. The SQL server driver that we are using gives an error return for the type on nchar related columns. SQL Server does not support UTF-8 in CHAR related fields. Does anyone have any pointers on using SQL Server with Unicode and JDBC? - Tim
