Both the isql and the bcp utilities automatically support unichar data if the server supports two-byte character data. bcp now supports 4K, 8K and 16K page sizes.
If the client’s default character set is UTF-8, isql displays two-byte character data, and bcp saves two-byte character data in the UTF-8 format. Otherwise, the data is displayed or saved, respectively, in two-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.