Obrigado Osvado Só para ter certeza do trabalhao que vou ter...
Flávio Osvaldo Kussama wrote: > > 2010/6/18 flavior <[email protected]>: >> >> Gostaria de confirmar com os senhores. >> >> O pg_dump NAO converte uma base que esta em 'SQL_ASCII' para outro >> encoding >> (UTF8)? >> Estou usando o comando : >> pg_dump -a -d -C --user=postgres --table=dbs --encoding=UTF8 tbase > >> dbs_utf8.sql >> > > > Do manual [1]: > " The SQL_ASCII setting behaves considerably differently from the > other settings. When the server character set is SQL_ASCII, the server > interprets byte values 0-127 according to the ASCII standard, while > byte values 128-255 are taken as uninterpreted characters. No encoding > conversion will be done when the setting is SQL_ASCII. Thus, this > setting is not so much a declaration that a specific encoding is in > use, as a declaration of ignorance about the encoding. In most cases, > if you are working with any non-ASCII data, it is unwise to use the > SQL_ASCII setting, because PostgreSQL will be unable to help you by > converting or validating non-ASCII characters." > > Osvaldo > [1] http://www.postgresql.org/docs/current/interactive/multibyte.html > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- View this message in context: http://old.nabble.com/pg_dump-tp28930644p28948762.html Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
