Обсуждение: Converting CP1252 to UTF-8

I have a total of 60GB's in several database with encoding set to
SQL_ASCII. I am using version 8.0. The data has always been encoded in
CP1252 prior to inserting into the database.

I have characters between 0x80 and 0x9F scattered throughout the
databases which I cannot loose.

I noticed in version 8.1 I can set the database encoding to WIN1252.
Will the following work to keep from loosing the above characters:

Upgrade to 8.1
Create the databases in CP1252
Restore the data
Dump the databases again to set the appropriate encoding in the dump file
Create the databases with UTF-8 encoding
Restore the data

Thanks in advance,

Doug

--

Robert D Oden
Database Marketing Technologies, Inc
951 Locust Hill Circle
Belton MO 64012-1786

Ph:  816-318-8840
Fax: 816-318-8841

roden@dbasetek.com