Re: how to force collation on a create view table statement?
> So each of those needs to be the same?
yep
> 1) can any of those be "set" in the view creation?
I don't know a way to embed SET... cmds in SELECTs.
> 2) as I'm on the cautious side of changing a live DB with lots of older code/application
That character_set_server setting is a misfit with the the other charset settings, should be changed. Every app needs to do SET NAMES... or equivalent. If some are not, there's work to do. making the changes then regression testing in the testbed should flush out the problems waiting.
Subject
Written By
Posted
Re: how to force collation on a create view table statement?
January 24, 2019 02:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.