Chapter 9: Configuring Character Sets, Sort Orders, and Languages

Converting to UTF-8

The first step towards using Unicode is 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 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

Restart the server to modify the default character set and re-create indexes on the system tables. Restart 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

View this book as PDF