Re: Fwd: EB12.1.3 Migration To UTF
Posted by
khaledharb72 on
Jan 23, 2019; 2:47pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EB12-1-3-Migration-To-UTF-tp7067p7141.html
- I know that you already done successfully a project for changing EBS database character set to UTF ; can you give me a guide line for what you really do !!!
- Our organization didn't approve shorten data Nor Oracle company support to enlarge field length !!!
- Why EBS didn't support CHAR schemantics .. varchar field will be same in length !!!
On Wed, Jan 23, 2019 at 3:42 PM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <
[hidden email]> wrote:
There ar 3 choices if you do NOT want dataloss ;
1)enlarge the columns size
2)migrate to CHAR semantics
3)shorten the data.
CHAR schemantics is not supported by EBS.
So what you can do is to enlarge the column size or shorten the data..
Hoıwever; I can't directly recommend any of these, because this is a standard table, and the data inside it is your data..
So, if your organization approves shortening the data, then you can proceed with that.. (I don't think they will approve it, but it depends on the data..)
Englarging the column seems promising, but since it is a standard table, I recommend you to open a SR and get approval from Oracle for that.
Please review this note -> Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) in 8i, 9i , 10g and 11g (Doc ID 260192.1)