SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Still problems with german special characters (General)

posted by hartundweich(R) Homepage, Austria, 06.04.2016, 19:41

Hi,

another idea: before upgrading to 3.2.0 and moving to another box I did an
dump of the old 2.8.32 using --encoding='UTF-8':

pg_dump --encoding='UTF-8' yoursqlledgerdb > dump.20160321

The old database was on LATIN1, dump contains "SET client_encoding =
'UTF-8';"

Ciao!

I've just tried - it does not matter if I use "--encoding..." at pg_dump - the resulting SQL file always contains "SET client_encoding = 'UTF-8';"

So what to do next? Just empty my production database and import the SQL file? How can I make this DB dump to work on a new dataset? I don't want to play around with my production data and maybe make all financial data unuseable...

 

Complete thread:

Back to the forum
Board view  Mix view
971 Postings in 319 Threads, 324 registered users, 56 users online (0 registered, 56 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum