��������� � in databricks

Shambhu Rai 1,401 Reputation points
2024-02-02T11:43:29.5233333+00:00

Hi Expert, how to replace below wild character from databricks ��������� �

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,854 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 39,026 Reputation points
    2024-02-09T07:46:52.03+00:00

    You get the question marks, when you handle Unicode/UTF-8 as ASCII text, example:

    SELECT '维基百科' AS [Wrong],
          N'维基百科' AS [Right]
    
    
    0 comments No comments