RE: alter database character set (Was: RE: 'internal' role and 9i)
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 Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) in ALTER DATABASE command. THis can be used to convert the database character set if the existing char set (national charset) is the superset of the db charset. You can just run the ALTER Database command to convert the db charset. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation. I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9 that doesn't like it. I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE and INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter database character set (Was: RE: 'internal' role and 9i)
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 changing to a lower character set works, what's the syntax? Personally, I can't imagine how that's possible. Thanks. Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: 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 Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) in ALTER DATABASE command. THis can be used to convert the database character set if the existing char set (national charset) is the superset of the db charset. You can just run the ALTER Database command to convert the db charset. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation. I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9 that doesn't like it. I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE and INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter database character set (Was: RE: 'internal' role and 9i)
It does. If you do a full import from a US7ASCII database into a WE8ISO8859P1 database and you need to change the WE8ISO8859P1 database to US7ASCII then this is the way to do it. ALTER DATABASE CHARACTER SET internal_use us7ascii; Make sure you know what you're doing. See Metalink Doc Id 100751.996 Yong Huang yong321 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: RE: alter database character set (Was: RE: 'internal' role and 9i) ml-errors 11/18/2003 12:49 PM Please respond to ORACLE-L 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 changing to a lower character set works, what's the syntax? Personally, I can't imagine how that's possible. Thanks. Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: 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 Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) in ALTER DATABASE command. THis can be used to convert the database character set if the existing char set (national charset) is the superset of the db charset. You can just run the ALTER Database command to convert the db charset. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation. I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9 that doesn't like it. I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE and INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Re: alter database character set (Was: RE: 'internal' role and 9i)
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: Tuesday, November 18, 2003 7:49 PM 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 changing to a lower character set works, what's the syntax? Personally, I can't imagine how that's possible. Thanks. Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: 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 Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) in ALTER DATABASE command. THis can be used to convert the database character set if the existing char set (national charset) is the superset of the db charset. You can just run the ALTER Database command to convert the db charset. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation. I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9 that doesn't like it. I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE and INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).