| Character Set [message #56049] |
Tue, 04 March 2003 05:55  |
Pierre BITAR
Messages: 5
Registered: September 2002
|
Junior Member |
|
|
Hi there,
Is it possible to change the Character set from UTF7 to UTF8 on Oracle 8i/AIX 4.3.3 without recreating the database? The issue is that I cannot store French characters (é, ç, è,....)
Help is very appreciated,
|
|
|
|
| Re: Character Set [message #56060 is a reply to message #56049] |
Tue, 04 March 2003 13:08  |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
The short answer is no.
An unload via a set of selects and then use sqlloader to
reload into the new database, is really your only way to do
this.
Or - create a new database, link the 2 and create table as
select * from table@old
However test this carefully.
good luck
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
