September 14th, 2013, 08:50 PM
Join Date: Sep 2013
Time spent in forums: 5 m 34 sec
Reputation Power: 0
Originally Posted by grashmi13
We are converting WE8ISO8859P1 oracle db characterset to AL32UTF8. Before conversion, i want to check implication on PL/SQL code for byte based SQL functions.
What all points to consider while checking implications on PL/SQL code?
I could find 3 methods on google surfing, SUBSTRB, LENGTHB, INSTRB. What do I check if these methods are used in PL/SQL code?
What all other methods should I check?
What do I check in PL/SQL if varchar and char type declarations exist in code?
How do i check implication of database characterset change to AL32UTF8 for byte bases SQL function.
Thanks in Advance.
SUBSTR and LENGTH functions are being used in PL/SQl code. Could these methods cause some issue if database character set is changed to AL32UTF8?