The first step towards using Unicode will be to extract the data and convert it to UTF-8 form.
% bcp xpubs..authors out authors.utf8.bcp -c -Jutf8 -Usa -P
The next step will be to install UTF-8 as the default character set in the server:
% charset -Usa -P binary.srt utf8 % isql -Usa -P > sp_configure 'default sortorder id', 50, 'utf8' > go > shutdown > go
Then reboot the server. It will modify the default character set, recreate indexes on the system tables, then exit. Reboot the server a second time. Then reload the data:
% isql -Usa -P > sp_dboption xpubs, 'select into', true > go > use xpubs > go > checkpoint > go > delete from authors > go > quit
% bcp xpubs..authors in authors.utf8.bcp -c -Jutf8 -Usa -P
