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

[Busser, Jim]

On 2011-11-14, at 7:33 PM, Jim Busser wrote:

> Please wait on the Brazil patching.
> 
> I am refactoring :-)

-- 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');

-- Jim