Re: character set problem in Oracle 10g

From: Mike <dontwannasay_at_home.com>
Date: Fri, 13 May 2005 22:22:54 -0500
Message-ID: <Xns9655CF5563FD8dontwannasaycom@216.196.97.136>

"tri dhungana via DBMonster.com" <forum_at_nospam.DBMonster.com> wrote in news:221c37180f454d27ada332cde4938a37_at_DBMonster.com:

> I have just install oracle 10g Enterprise Edition in winXp and my
> character set on the db server is
>

(Snipped)
>
> i am using some other fonts that resemble like Hindi.Now how can i
> change my character set on db server. I have tried using
> Local builder....i could not get it right......can anyone tell me.....
>

Well, you will need to convert your database to Unicode. Any other change will result in code-page madness. We just completed a 9-month project to convert our 10-year-old SAP system to Unicode, but a new database should be easy.

Export your database (FULL=Y, USERID=SYSTEM)
Destroy your database.
Recreate your database using the AL32UTF8 characterset.
Import your database.

Received on Fri May 13 2005 - 22:22:54 CDT