Imp/Exp character set problem !??? [message #70686] |
Sun, 14 July 2002 02:12 |
La Hoang Gia
Messages: 3 Registered: July 2002
|
Junior Member |
|
|
I've just moved my application from Solaris system to WinNT system but all data in new system displays in another charater set...could you please tell me how can i detect and reset character set for my database ?
Best regards.
|
|
|
Re: Imp/Exp character set problem !??? [message #70768 is a reply to message #70686] |
Mon, 22 July 2002 03:03 |
sunil bhola
Messages: 58 Registered: July 2002
|
Member |
|
|
For this there is command in Oracle
select name,value from sys.props$;
it will display all the parameter default parameter i.e. character set, export version, global name etc.
to change the character set in Oracle 8i
shutdown immediate;
startup mount;
alter database character set <<whatever characterset>>
alter database open
|
|
|