Skip to content

Instantly share code, notes, and snippets.

@rogeriolino

rogeriolino/novosga-utf8-fix.sql

Last active January 25, 2016 20:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rogeriolino/35f25967d8ebe9193c46 to your computer and use it in GitHub Desktop.
Save rogeriolino/35f25967d8ebe9193c46 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
novosga-utf8-fix.sql
-- fixUtf8 function required https://gist.github.com/rogeriolino/22d911fbe25538838bb3
-- IMPORTANT: don't run more than 1 time!
UPDATE unidades SET nome = fixUtf8(nome);
UPDATE prioridades SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE grupos SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE cargos SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE locais SET nome = fixUtf8(nome);
UPDATE atendimentos SET nm_cli = fixUtf8(nm_cli), ident_cli = fixUtf8(ident_cli);
UPDATE historico_atendimentos SET nm_cli = fixUtf8(nm_cli), ident_cli = fixUtf8(ident_cli);
UPDATE servicos SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE usuarios SET nome = fixUtf8(nome), sobrenome = fixUtf8(sobrenome);
UPDATE painel_senha SET nome_cliente = fixUtf8(nome_cliente), documento_cliente = fixUtf8(documento_cliente), msg_senha = fixUtf8(msg_senha);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment