alter database character set (Was: RE: 'internal' role and 9i)

2003-11-18 Thread Yong Huang
Gopal, Are you saying with an undocumented parameter or command, I can alter database (national) character set us7ascii even if my current (national) character set is utf8? Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: INTERNAL_USE is an keyword (to enable an undocumented feature)

RE: alter database character set (Was: RE: 'internal' role and 9i)

2003-11-18 Thread K Gopalakrishnan
INSERT STANDARD DISCLAIMERS Yes. You can use INTERNAL_USE keyword to convert the database character set. I think there is a utility called 'csscan' character set scanner which can be used to determine the possibility of the INTERNAL_USE conversion. END DISCLAIMERS Best Regards, K

RE: alter database character set (Was: RE: 'internal' role and 9i)

2003-11-18 Thread Yong Huang
Gopal, In case I didn't make my message clear, I wanted to know if using that keyword allows us to change character set from a superset to a subset (e.g. from UTF8 to US7ASCII). The documented command ALTER DATABASE CHARACTER SET new charset is only for changing from a subset to a superset. If

RE: alter database character set (Was: RE: 'internal' role and 9i)

2003-11-18 Thread Thomas Day
by: Subject: RE: alter database character set (Was: RE: 'internal' role and 9i) ml-errors

Re: alter database character set (Was: RE: 'internal' role and 9i)

2003-11-18 Thread Tanel Poder
I've never used that, but this syntax seems to work: alter database character set internal_use us7ascii; Of course, you could lose some characters or mess up your data completely that way... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: