https://community.databricks.com/t5/data-engineering/how-to-set-charset-encoding-in-sql-view/m-p/3878#M770 <P>Hi! I have a SQL query that has a where-clause that checks a string attribute not being equal to e.g. 'シミュレータに接続されていません' (Japanese). This works fine when running the query in SQL Editor ad hoc, but creating a view with the same query, the special characters are converted to '?????' in hive_metastore looking at the view-details. How can I preserve the special characters in the view representation? Right now I've implemented a workaround with hex(encode(string_attribute)).</P><P>Running in Azure databricks environment with Spark 3.3.2</P> Tue, 30 May 2023 13:57:28 GMT AEM 2023-05-30T13:57:28Z https://community.databricks.com/t5/data-engineering/how-to-set-charset-encoding-in-sql-view/m-p/3878#M770 <P>Hi! I have a SQL query that has a where-clause that checks a string attribute not being equal to e.g. 'シミュレータに接続されていません' (Japanese). This works fine when running the query in SQL Editor ad hoc, but creating a view with the same query, the special characters are converted to '?????' in hive_metastore looking at the view-details. How can I preserve the special characters in the view representation? Right now I've implemented a workaround with hex(encode(string_attribute)).</P><P>Running in Azure databricks environment with Spark 3.3.2</P> Tue, 30 May 2023 13:57:28 GMT https://community.databricks.com/t5/data-engineering/how-to-set-charset-encoding-in-sql-view/m-p/3878#M770 AEM 2023-05-30T13:57:28Z