Does anyone has experience for changing postgreSQL to oracle database for confluence?
I exported .xml file in confluence with postgreSQL database and imported to the same version confluence but with empty database (oracle), the import failed with error:
Caused by: java.sql.SQLException: ORA-12899: value too large for column "CONFUSER"."ATTACHMENTS"."ATTACHMENT_COMMENT" (actual: 259, maximum: 255)
I checked the data in postgreSQL database, the comment do have 255 characters, but why it became 259 characters in Oracle?
I ran the following SQL and returned is UTF8:
SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = 'confluence';
The new oracle database is using UTF8 encoding.
Anyone can help? Thanks
It is possible that certain special characters in the comment take up more than 1 value, causing the total value to go over the maximum of 255. Please have a look at this page to see if it contains any useful information for you.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG