I had posted this question initially on "General database Discussions", Not sure if that is the correct place as per new forum. So posting it here in SQL/PLSQL.
We have moved from Oracle version 12.1.0.2 to 19C. And the character set(i.e. NLS_CHARACTERSET ) also been changed from US7ASCII in 12.1 to AL32UTF8 now in 19C. For one of the table column having XMLTYPE earlier it used to fail for some non-english characters and accordingly downstream logic was implemented. But now that in 19C and are on AL32UTF8, its accepting all those characters and causing issue/failure in downstream. So to have a quick fix, want to know, If there any way exists in 19C, to just enable character set "US7ASCII" for a specific column of the table with database level NLS_CHARACTERSET remain in AL32UTF8? or any other way possible?
I see in few places in internet, something as below can alter the character set of specific column in a table in Mysql. Though i have not tested it in any Mysql database. But i see this syntax doesn't work on oracle, as i tested on a Oracle dev database. So wondering if there is something matching to this in Oracle? or by any other means we can achieve same?
ALTER TABLE TAB_TEST MODIFY COl1 CHAR(50) CHARACTER SET US7ASCII;