| From: | Marcos <mjs_ops(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Encoding Problem |
| Date: | 2006-01-13 17:10:52 |
| Message-ID: | 1137172252.4836.21.camel@servidor |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2006-01-13 17:23:42 | Temporary tables |
| Previous Message | Doug McNaught | 2006-01-13 16:34:55 | Re: Moving PostgreSQL data directory on Windows |