Archive version 5.23.0 / 5.23.1 with Oracle DB requires person_name table column datatype modifications

[vrindanayak]

person_name table columns replacement done as part of Make literal person name matching fully DICOM compliant issue created incorrect datatypes (i.e. varchar2(255 char)) for the replaced columns instead of nvarchar2(255)

[vrindanayak]

To rectify the datatypes of person_name.alphabetic_name, person_name.ideographic_name and person_name.phonetic_name :

• For archives already running with version 5.23.0 / 5.23.1 (and already containing some data in person_name table), apply following script

alter table PERSON_NAME modify alphabetic_name nvarchar2(255) modify ideographic_name nvarchar2(255) modify phonetic_name nvarchar2(255);

• For archives running on versions upto 5.22.6 and planned for upgrades to version 5.23.0 and above, apply rectified update-5.23-oracle.sql script instead of applying the script from 5.23.0 released package for oracle