encoding problem about amsterdamumcdb

[patrickthoral]

Just to verify: did you clone the repository and are running the setup-amsterdamumc.ipynb notebook or did you copy and paste the cells to a new notebook? Are you using the latest release of the database (v.1.0.2)?

[XiangBu]

yes, I clone the repository and use v.1.0.2. I kind of doubt the files were broken while unzipping. I'll try again and see if it works and I'll let you know. Thanks for ur kind reply.

[patrickthoral]

You might use https://github.com/AmsterdamUMC/AmsterdamUMCdb/blob/master/tools/unzip.ipynb to unzip the latest version. This should not produce any errors. However, I am a bit surprised that the cell below Create admissions table fails, since that one does not even contain special characters and does not access the data. What error does the cell produce when you run the original cell/notebook. Is this the first cell with an error?

[XiangBu]

Yes. Create admissions table is the first cell that fails. I don't know why, but problem solved by putting the following two together. Still confused. but It seems everything goes well so far.
SET CLIENT_ENCODING TO 'win1252'
SET CLIENT_ENCODING TO 'utf8'

[patrickthoral]

Some of the documentation of postgres suggests that a non-standard codepage on the postgres server on Windows (i.e. not WIN1252) prevents the WIN1252 codepage from working. I assume this is basically not related to AmsterdamUMCdb. I'm closing this now, but feel free to re-open.