Login  Register

Re: EB12.1.3 Migration To UTF

Posted by khaledharb72 on Jan 23, 2019; 9:36am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EB12-1-3-Migration-To-UTF-tp7067p7131.html

Need to convert database character set From  AR8MSWIN1256  to  AL32UTF8 
I send Excel attachment for sample of DMU Data Conversion truncation for columns Report 


Question:
. We found that minimize (shorten) EBS table field data to fit AL32UTF8 is applicable because it related to Key data like table MTL_SYSTEM_ITEMS_B field SEGMENT1
. We need to change nls_length_semantics from BYTE to CHAR on whole database 
  How to do that on already EBS Database data and does this solution applicable for EBS and can work ???


On Tue, Jan 15, 2019 at 10:21 AM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:
The  length of the contents of those fields should fit your new Character set. 

So tell me, from which character set are you trying to convert your database to UTF8? 
Also send me the screenshot of the problem.. (I want to see the DMU screen) 

If you reply to this email, your message will be added to the discussion below:
http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EB12-1-3-Migration-To-UTF-tp7067p7084.html
To unsubscribe from EB12.1.3 Migration To UTF, click here.
NAML


On Tue, Jan 15, 2019 at 10:21 AM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:
The  length of the contents of those fields should fit your new Character set.

So tell me, from which character set are you trying to convert your database to UTF8?
Also send me the screenshot of the problem.. (I want to see the DMU screen)


If you reply to this email, your message will be added to the discussion below:
http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EB12-1-3-Migration-To-UTF-tp7067p7084.html
To unsubscribe from EB12.1.3 Migration To UTF, click here.
NAML

Sample.Critical.EBS.DataTruncationIssues.xlsx (13K) Download Attachment