CODEWITHSUNDEEP
macospostgresqlunicodepsql
MTR
MTR

Reputation: 1431

PSQL character encoding/display strangeness

I confess, this was stupid on my part, but I deleted some .lproj (Mac) files that I thought I didn't need. I thought I was careful to only remove those that really weren't necessary, but I suspect this is where the problem started.

When I go into psql and select from table.whatever I get characters like this at the top of the output (where the | and ___ lines would normally be displayed) :

<E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80> <E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2>
<94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94><80><E2><94>

Any suggestions as to how I might be able to fix this? I uninstalled and reinstall pgsql, but that didn't work.

Upvotes: 1

Views: 60

Answers (1)

galli2000
galli2000

Reputation: 598

In macOS Terminal preferences, set the locale environment variables on startup, and restart your terminal. The problem should be gone. enter image description here

Upvotes: 1

Related Questions