Re: Change Chracter Set - UTF8 to US7ASCII

From: Chris Weiss <weisschr_at_tcimet.net>
Date: Fri, 27 Jul 2001 15:51:05 -0400
Message-ID: <9jsg9g$2q37$1@msunews.cl.msu.edu>

You cannot go back once you commit to UTF8. If you want US7ASCII you will have to export all of your data, burn the database to the ground, rebuild, and import your data.

When you export you can specify the character set to use.

Good Luck,
Chris Weiss

"jp" <jpfrancois_at_bigfoot.com> wrote in message news:ekg87.37262$Iz3.7237464_at_news2-win.server.ntlworld.com...
> Hi,
>
> Is it possible to change the character set of a database from UTF8 back to
> US7ASCII. We have no data in the database that should use UTF8 - we
imported
> data from a database with US7ASCII character set.
>
> When I try the alter database command I get an error 12712 saying it must
be
> a superset.
>
> I am trying to avoid a restore (large database).
>
> thanks in advance,
>
> JP
>
>
Received on Fri Jul 27 2001 - 14:51:05 CDT