User Tools

Site Tools


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 15:21] sweitmannpsql_ascii_2_utf8 [2019/03/12 16:42] sweitmann
Line 13: Line 13:
 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 <Non-ISO-extended-ASCII-FILE.sql >UTF8_database_dump.sql
 Check the result by typing: Check the result by typing:
  
Line 34: Line 35:
        
    
- 
psql_ascii_2_utf8.txt · Last modified: 2023/02/20 14:52 by sweitmann