Both the isql and the bcp utilities automatically support unichar data if the server supports 2-byte character data. bcp now supports 4K, 8K and 16K page sizes.
If the client’s default character set is UTF-8, isql displays 2-byte character data, and bcp saves 2-byte character data in the UTF-8 format. Otherwise, the data is displayed or saved, respectively, in 2-byte Unicode data in binary format.
Use isql -Jutf8 to set the
client character set for isql.
Use bcp -Jutf8 to set the
client character set for the bcp utility.
