UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 51771: character maps to <undefined>

[skupr-anaconda]

We tested sqlglot 26.3.8 on win-64.

Fully reproducible code snippet
The test test_cts_file(self) fails on win-64 with an error:

 def decode(self, input, final=False):
   return codecs.charmap_decode(input,self.errors,decoding_table)[0]
   UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 51771: character maps to <undefined>
     ..\_test_env\lib\encodings\cp1252.py:23: UnicodeDecodeError

The test has a bug.
It should have encoding='utf8' like this:
with open(os.path.join(FIXTURES_DIR, "jsonpath", "cts.json"), encoding='utf8') as file:
instead of:
with open(os.path.join(FIXTURES_DIR, "jsonpath", "cts.json")) as file:

Also, see AnacondaRecipes/sqlglot-feedstock#5

[georgesittas]

Thanks for reporting this, fixed.