I have a requirement to retrieve list of AEM pages and its properties. So I'm doing it through SQL query in java to retrieve. Everything is coming fine except a single property which has translated text. Property text is always been replaced with ??? instead of the language text. That property is a richtext field in AEM dialog.
Do I need to add something in query to retrieve the translated(language) text as it is?