CODEWITHSUNDEEP
sqldb2ibm-clouddatabase-administrationdb2-luw
Red
Red

Reputation: 65

DB2 LUW double-byte characters not decoded on prod db , but in test db they are decoded

I have an application that saves url meta data and the double byte characters correctly save in our test db when running the application locally, but our prod dB doesn’t…

Not sure what’s going on, can anyone point me in the right direction?

Column data type is varchar.enter image description here

Upvotes: 0

Views: 147

Answers (1)

Red
Red

Reputation: 65

Solved this by setting the locale in our Docker file to utf-8.

RUN apt-get update
RUN apt-get install -y locales locales-all
ENV LC_ALL en_US.UTF-8
ENV LANG en_US.UTF-8
ENV LANGUAGE en_US.UTF-8

Upvotes: 1

Related Questions