When I connect to db using pgAdmin get message:
"The database odm2_db is created to store data using the SQL_ASCII encoding. This encoding is defined for 7 bit characters only; the meaning of characters with the 8th bit set (non-ASCII characters 127-255) is not defined. Consequently, it is not possible for the server to convert the data to other encodings. "
The Earthchem data definitely has some characters that are outside of the 7 bit ascii space. Shouldn't the db use UTF_8. I think this explains why I couldn't use a text pg_dump to restore my EarthChem Db to the Docker container odm2_db-- had to use pg_restore and directory with explicit character encoding parameter.
When I connect to db using pgAdmin get message:
"The database odm2_db is created to store data using the SQL_ASCII encoding. This encoding is defined for 7 bit characters only; the meaning of characters with the 8th bit set (non-ASCII characters 127-255) is not defined. Consequently, it is not possible for the server to convert the data to other encodings. "
The Earthchem data definitely has some characters that are outside of the 7 bit ascii space. Shouldn't the db use UTF_8. I think this explains why I couldn't use a text pg_dump to restore my EarthChem Db to the Docker container odm2_db-- had to use pg_restore and directory with explicit character encoding parameter.