International SQL-Ledger Network Association

User Tools

Site Tools

Trace:
psql_ascii_2_utf8

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
psql_ascii_2_utf8 [2014/10/20 14:42] – sweitmannpsql_ascii_2_utf8 [2014/10/20 14:44] – sweitmann
Line 1: Line 1:
 ===== Convert PostgreSQL database from SQL_ASCII to UTF8 ===== ===== Convert PostgreSQL database from SQL_ASCII to UTF8 =====
  
-Login to your server as "root" and install the Recode tool. In Linux Debian you do this by typing:+Login to your server as "root" and install the 'Recode' tool. In Linux Debian you do this by typing:
      apt-get install recode      apt-get install recode
 Then switch to the "postgres" account: Then switch to the "postgres" account:
Line 29: Line 29:
     SET client_encoding = 'UTF8';     SET client_encoding = 'UTF8';
 Create a new database: Create a new database:
-    createdb UTF8_database_name+    createdb new_UTF8_database_name
 And import the UTF8_database_dump.sql And import the UTF8_database_dump.sql
-    psql UTF8_database_name < UTF8_database_dump.sql+    psql new_UTF8_database_name < UTF8_database_dump.sql
 That's it!    That's it!   
    
psql_ascii_2_utf8.txt · Last modified: 2023/02/20 14:52 by sweitmann