Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle 8i + changing language

0 views
Skip to first unread message

Ed_Zep

unread,
Jan 3, 2003, 9:04:37 PM1/3/03
to
Hi.

I have to change the character set of the databases at our university from
US7ASCII so that we can print European accents on letters. Eg. ç, è, etc.
This has to include western and central/eastern European.

My questions are:

1. Can I have WEISO... and EEISO... on the same database at the same time?

2. If so, what's the best way of doing this? Do I need to export, recreate
the db. and import having changed the character set i the crdb####.sql file?
I tried this, but had problems.
Is it possible to have a script that rebuilds the database without data and
then I can do the import?

I know Oracle 8i has a utility to change the character set without having to
rebuild the db. Has anyone used it? Should I use it?

Many thanks in advance.

Happy New Year.

Ed.


Beserko

unread,
Jan 4, 2003, 1:28:03 AM1/4/03
to
Check out if you could do it with Unicode instead of
ISOXXX which are subsets of Unicode.

Sybrand Bakker

unread,
Jan 4, 2003, 8:00:21 AM1/4/03
to
On Sat, 4 Jan 2003 02:04:37 -0000, "Ed_Zep" <ed_...@ntlworld.com>
wrote:

1 You can have a characterset and a national characterset
2 If you are on 8.1 you can issue an ALTER DATABASE statement
Provided you follow the procedure in the docs and/or on Metalink and
your characterset is a superset of US7ASCII (which WE8ISO... are), it
will work without problem.


>Happy New Year.
>
>Ed.
>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Kenneth Koenraadt

unread,
Jan 4, 2003, 10:08:58 AM1/4/03
to
Beserko <beser...@yahoo.ca> wrote in message news:<pan.2003.01.04.06...@yahoo.ca>...

Hi Ed,

In short, you can easily change the character set of your db IF the
new character set is a superset of the old AND if they are both
single-byte sets :


ALTER DATABASE CHARACTER SET <new set>;
ALTER DATABASE NATIONAL CHARACTER SET <new national set> ;

If you want to have both WEISO... and EEISO in your DB, make WEISO...
the character set and EEISO... the national character set in above.

This applies to 8i. In 9i you are forced to use Unicode as National
character set. You should consider to convert both character sets to
Unicode once and for all.

If you wanna change your charset from a single-byte to a multi-byte
charset or from an old charset which is not a subset of the new one,
more steps are involved. See "Oracle9i Globalization Support Guide"
for details.

- Kenneth Koenraadt

Beserko

unread,
Jan 5, 2003, 1:37:22 AM1/5/03
to
Maybe you will find you answer here (Oracle doc on the subject) :
http://balrog.wu-wien.ac.at/sql/a96529.pdf

On Fri, 03 Jan 2003 21:04:37 -0500, Ed_Zep wrote:

0 new messages