Re: [Gnumed-devel] Updating dem listings for Brazil

[Karsten Hilbert]

On Tue, Nov 15, 2011 at 03:50:02AM +0000, Jim Busser wrote:

> -- note: the lines that follow were contributed as UTF8
> -- but I am not sure whether the encoding might change downstream
> -- and therefore whether any particular client encoding should apply when 
> issuing
> 
> UPDATE dem.state SET code = 'AP' WHERE name = 'Amapa' AND country = 'BR';
> UPDATE dem.state SET code = 'AM' WHERE name = 'Amazonas'  AND country = 'BR';
> UPDATE dem.state SET code = 'MT' WHERE name = 'Mato Grosso'  AND country = 
> 'BR';
> UPDATE dem.state SET code = 'PB' WHERE name = 'Paraiba'  AND country = 'BR';
> UPDATE dem.state SET code = 'PR' WHERE name = 'Parana'  AND country = 'BR';
> 
> select i18n.upd_tx('pt_BR', 'Ceara', 'Ceará');
> select i18n.upd_tx('pt_BR', 'Espirito Santo', 'Espírito Santo');
> select i18n.upd_tx('pt_BR', 'Goias', 'Goiás');
> select i18n.upd_tx('pt_BR', 'Maranhao', 'Maranhão');
> select i18n.upd_tx('pt_BR', 'Para', 'Pará');
> select i18n.upd_tx('pt_BR', 'Paraiba', 'Paraíba');
> select i18n.upd_tx('pt_BR', 'Parana', 'Paraná');
> select i18n.upd_tx('pt_BR', 'Piaui', 'Piauí');
> select i18n.upd_tx('pt_BR', 'Rondonia', 'Rondônia');
> select i18n.upd_tx('pt_BR', 'Sao Paulo', 'São Paulo');

I should like to see this saved in a file explicitely
declared utf8 encoded and mail it utf8 encoded.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346