topic How to use multi character encodings in Delta Tables? in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15894#M10163 <P>Can we mix different encodings in Delta tables? Downstream needs different character encodings like UTF-8 and Shift JIS.</P> Wed, 29 Jun 2022 01:40:58 GMT ShuImamura 2022-06-29T01:40:58Z How to use multi character encodings in Delta Tables? https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15894#M10163 <P>Can we mix different encodings in Delta tables? Downstream needs different character encodings like UTF-8 and Shift JIS.</P> Wed, 29 Jun 2022 01:40:58 GMT https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15894#M10163 ShuImamura 2022-06-29T01:40:58Z Re: How to use multi character encodings in Delta Tables? https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15895#M10164 <P>I don't think that it is possible.</P><P>Using an alternative encoding might be possible (you can for csv files, but for delta lake I did not find an option to do that).</P><P>But even with that hypothetical alternative encoding, I realyl doulbt mixing will work as the encoding is typically set for the whole file, not just a part of it.</P><P>​</P> Wed, 29 Jun 2022 11:15:56 GMT https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15895#M10164 -werners- 2022-06-29T11:15:56Z Re: How to use multi character encodings in Delta Tables? https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15897#M10166 <P>@Werner Stinckens​&nbsp;thanks for answering!</P> Wed, 29 Jun 2022 20:38:43 GMT https://community.databricks.com/t5/data-engineering/how-to-use-multi-character-encodings-in-delta-tables/m-p/15897#M10166 ShuImamura 2022-06-29T20:38:43Z