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
Last revisionBoth sides next revision
psql_ascii_2_utf8 [2014/10/20 14:42] – sweitmannpsql_ascii_2_utf8 [2023/02/20 14:52] – 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:
      su postgres      su postgres
-Now create a dump of your SQL_ASCII database:+Now start by creating a dump of your SQL_ASCII database:
  
      pg_dump SQL_ASCII_database_name > SQL_ASCII_database_dump.sql      pg_dump SQL_ASCII_database_name > SQL_ASCII_database_dump.sql
Line 11: Line 11:
  
     file SQL_ASCII_database_dump.sql     file SQL_ASCII_database_dump.sql
-You should get the following output: +You should get the following output:    
-    +
     SQL_ASCII_database_dump.sql: ISO-8859 text     SQL_ASCII_database_dump.sql: ISO-8859 text
-Then you convert your ISO-8859 file to UTF8 by typing:+Then you convert your ISO-8859 or CP1250 file to UTF8 by typing:
  
     cat SQL_ASCII_database_dump.sql | recode iso-8859-1..u8 > UTF8_database_dump.sql     cat SQL_ASCII_database_dump.sql | recode iso-8859-1..u8 > UTF8_database_dump.sql
 +    
 +    iconv -f CP1250 -t UTF-8 -c <Non-ISO-extended-ASCII-FILE.sql >UTF8_database_dump.sql
 Check the result by typing: Check the result by typing:
  
     file UTF8_database_dump.sql     file UTF8_database_dump.sql
 +You should now get the following output: 
  
-You should now get the following output:  
     UTF8_database_dump.sql: UTF-8 Unicode text     UTF8_database_dump.sql: UTF-8 Unicode text
- 
 Now open the new UTF8_database_dump.sql file with your favourite editor and change the line: Now open the new UTF8_database_dump.sql file with your favourite editor and change the line:
     SET client_encoding = 'SQL_ASCII';     SET client_encoding = 'SQL_ASCII';
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