keboola / php-db-import

MIT License
4 stars 0 forks source link

Encoding debug #7

Closed Halama closed 8 years ago

Halama commented 8 years ago

ODBC driver doesn't handle well UTF-8 characters:

INSERT INTO  "TEST" VALUES ('šperky.cz', 'módní doplňky.cz');

Results in: image

This behaviour is simulated in this PR. It can be executed running:

docker-compose run \                                   
  -e SNOWFLAKE_HOST=$SNOWFLAKE_HOST \
  -e SNOWFLAKE_PORT=$SNOWFLAKE_PORT \
  -e SNOWFLAKE_USER=$SNOWFLAKE_USER \
  -e SNOWFLAKE_PASSWORD=$SNOWFLAKE_PASSWORD \
  -e SNOWFLAKE_DATABASE=$SNOWFLAKE_DATABASE \
  -e SNOWFLAKE_WAREHOUSE=$SNOWFLAKE_WAREHOUSE \
  tests php odbc_test.php