dosubot[bot] commented on issue #22904: URL: https://github.com/apache/superset/issues/22904#issuecomment-2786935369
<!-- Greeting --> Hey @rusackas! I'm [Dosu](https://dosu.dev), your friendly bot here to help you tackle bugs, answer questions, and navigate your way to becoming a contributor. I'm here while you wait for a human maintainer. Let's get started! <!-- Answer --> The issue you're experiencing with the `array_agg` function in Postgres and the display of Russian (Cyrillic) text as "unicode gibberish" in Superset seems to be related to how Superset handles character encoding when fetching and displaying data. This is a known issue that has been discussed in the Superset community, as seen in the related GitHub issue #19982. A potential workaround, as suggested by a user, is to convert the array data into text using a SQL query like `SELECT array_agg(smth)::text`. This conversion might help in displaying the characters correctly in Superset's interface. Additionally, it might be helpful to check if there are any configuration settings in Superset or the database connection that could affect Unicode handling. Unfortunately, I couldn't find specific configuration settings related to Unicode handling in the Superset codebase. If this workaround doesn't resolve the issue, further investigation into the Superset codebase, particularly in areas handling query results and their conversion for display, might be necessary. The `querySuccess` and `fetchQueryResults` functions in `superset-frontend/src/SqlLab/actions/sqlLab.js` and the `ResultSet` component in `superset-frontend/src/SqlLab/components/ResultSet/index.tsx` are key parts of this process <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/actions/sqlLab.js)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/components/ResultSet/index.tsx)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/f2ec522e-af1a-4c5f-a9af-d9264667ae62?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
