Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 474 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
CK Editor 4 to 5: should we migrate existing html data in CLOB?

apex 20.2
We have stored html with CK Editor 4. Once we upgrade our page item to CK Editor 5 and fetch the existing html, it appears that the editor converts our html stored in CK Editor 4. When leaving the page unsaved, alert Warn on Unsaved Changes prompts, although the user did not change any data.
Looking in the database CLOB column with CK Editor 4 html, CK Editor 5 has changed
<p><span style="color:#008000"><strong>Check by "Show XML File".</strong></span></p>
to
<p><span style="color:#008000;"><strong>Check by "Show XML File".</strong></span></p>
Should we migrate the html stored with CK Editor 4? If yes, how to migrate?
Looking forward to your response.
Johan
Answers
-
Hi Johan,
I think this is a bug, it happened to me when we upgrade to 20.2.
It will prompt the Warning if you turn on the [Validation ==> Value Required] even if there is a text.
As a workaround I turn it off and create a validation to check the Rich Text Editor whether it is null or not.
-
Hi msammour,
Thank you for joining this discussion.
In our app we don't require a value. Still an alert prompts when value is not null.
Currently I'm in favor of migrating the html to CK Editor 5 syntax to phase out any prior CK Editor version and have consistent html syntax in table CLOB column. I wonder how to achieve this.
Johan
-
What do you mean of
migrating the html to CK Editor 5 syntax
You mean the CLOB data?
If you can share more details regarding the properties you've set will be better.
-
Hi msammour,
We refer to our example.
The same rich text stores differently in the database column with data type CLOB, depending on the version of CK editor used to interact with database column.
CKE4: <p><span style="color:#008000"><strong>Check by "Show XML File".</strong></span></p>
CKE5: <p><span style="color:#008000;"><strong>Check by "Show XML File".</strong></span></p>
Kind regards