Search Postgresql Archives

Encoding Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi.

I'm receiving this error message:

invalid UTF-8 byte sequence detected

SET search_path TO administracao,public;

CREATE OR REPLACE FUNCTION inserirTela(text,text,text) RETURNS text AS '
    DECLARE
        sName ALIAS FOR $1;
        sDesc ALIAS FOR $2;
        cSist ALIAS FOR $3;
    BEGIN
        SET search_path TO administracao,public;
        
        INSERT INTO telas (nome_tela,descricao,sistema) VALUES( sName, sDesc, cSist );
        RETURN ''Registro inserido com sucesso'';
    EXCEPTION 
        WHEN unique_violation THEN RETURN ''Ja existe uma tela com este nome'';
        WHEN others THEN RETURN ''Erro ao inserir registro'';
    END;
' LANGUAGE plpgsql;

The problem is in the RETURN messages... if it's oculted the error not occur.

What i do?

My database is UTF-8.

Thanks.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux