https://community.databricks.com/t5/data-engineering/how-to-keep-the-original-swedish-finnish-character-in-the-file/m-p/16292#M10493 <P></P> <P>So the answer was using the option("charset", "iso-8859-1")</P> <P></P> Thu, 19 Aug 2021 03:41:23 GMT irfanaziz 2021-08-19T03:41:23Z https://community.databricks.com/t5/data-engineering/how-to-keep-the-original-swedish-finnish-character-in-the-file/m-p/16291#M10492 <P></P> <P>The files are in ANSI format as it shows in the notepad, I could manuelly convert the files to utf8 and read it. But the files are really large. I dont want to download and upload the files. </P> <P>Is there way so i could keep the swedish/finnish characters ?</P> <P>I tried reading the file with iso-5589-1 encoding but to no avail.</P> <P>What would be the easy way to convert the files to utf8 encoding in the notebook or something easy.</P> <P></P> Wed, 18 Aug 2021 14:39:29 GMT https://community.databricks.com/t5/data-engineering/how-to-keep-the-original-swedish-finnish-character-in-the-file/m-p/16291#M10492 irfanaziz 2021-08-18T14:39:29Z https://community.databricks.com/t5/data-engineering/how-to-keep-the-original-swedish-finnish-character-in-the-file/m-p/16292#M10493 <P></P> <P>So the answer was using the option("charset", "iso-8859-1")</P> <P></P> Thu, 19 Aug 2021 03:41:23 GMT https://community.databricks.com/t5/data-engineering/how-to-keep-the-original-swedish-finnish-character-in-the-file/m-p/16292#M10493 irfanaziz 2021-08-19T03:41:23Z