International SQL-Ledger Network Association

User Tools

Site Tools

Trace: • integration_possibilities
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
psql_ascii_2_utf8 [2014/12/30 15:01] – external edit 127.0.0.1psql_ascii_2_utf8 [2024/09/25 06:21] (current) – external edit 127.0.0.1
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 these two commands:
  
     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:
  
Line 34: Line 36:
        
    
- 
psql_ascii_2_utf8.1419951670.txt.gz · Last modified: 2024/09/25 06:19 (external edit)