Hello,
When I get the results of an Oracle query, the columns containing japan characters come up weirdly, like it does not support the font.
?C?x???g?t?H?[???
???R?[?h
here is my env file and docker-compose.yml
// opt/redash/env
PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=INFO
REDASH_REDIS_URL=redis://redis:6379/0
POSTGRES_PASSWORD=i80dgWlOCfJbTgSa5rtPiZh3VQJJAzAq
REDASH_COOKIE_SECRET=XJzeV50x3NJHrGB9W0E6CLtCVlNlZEWd
REDASH_SECRET_KEY=jezelI7FfijtAtWlhp3fB8yhw4TrYbQ8
REDASH_DATABASE_URL=postgresql://postgres:i80dgWlOCfJbTgSa5rtPiZh3VQJJAzAq@postgres/postgres
REDASH_ADDITIONAL_QUERY_RUNNERS=redash.query_runner.oracle
NLS_LANG=AMERICAN_AMERICA.US7ASCII
ORACLE_CHARACTERSET=US7ASCII
// opt/redash/docker-compose.yml
version: “2”
x-redash-service: &redash-service
image: redash_oracle:latest
depends_on:
- postgres
- redis
env_file: /opt/redash/env
restart: always
services:
server:
<<: *redash-service
command: server
ports:
- “5000:5000”
environment:
REDASH_WEB_WORKERS: 4
REDASH_ADDITIONAL_QUERY_RUNNERS: “redash.query_runner.oracle”
NLS_LANG: “AMERICAN_AMERICA.US7ASCII”
ORACLE_CHARACTERSET: “US7ASCII”
scheduler:
<<: *redash-service
command: scheduler
environment:
QUEUES: “celery”
WORKERS_COUNT: 1
scheduled_worker:
<<: *redash-service
command: worker
environment:
QUEUES: “scheduled_queries,schemas”
WORKERS_COUNT: 1
adhoc_worker:
<<: *redash-service
command: worker
environment:
QUEUES: “queries”
WORKERS_COUNT: 2
REDASH_ADDITIONAL_QUERY_RUNNERS: “redash.query_runner.oracle”
NLS_LANG: “AMERICAN_AMERICA.US7ASCII”
redis:
image: redis:5.0-alpine
restart: always
postgres:
image: postgres:9.6-alpine
env_file: /opt/redash/env
volumes:
- /opt/redash/postgres-data:/var/lib/postgresql/data
restart: always
nginx:
image: redash/nginx:latest
ports:
- “80:80”
depends_on:
- server
links:
- server:redash
restart: always
Thank you in advance for your help, Redash is great.