close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 15 years ago

Closed 15 years ago

#833 closed defect (fixed)

Sometimes DBExecQuery doesn't show error messages when database engine is PostGreSQL

Reported by: Víctor de Buen Remiro Owned by: Jorge
Priority: highest Milestone: Mantainance
Component: Database Version: 2.0.1
Severity: major Keywords:
Cc:

Description

This query doesn't works due to an invalid encoding but TOL doesn't shows any error message:

INSERT INTO general.object_d_declare VALUES
(1,'Ine.Emp.Emp.Nac.TotGruCNA.Tot','Área temática: Datos de empresas;[[BR]] Concepto: Empresas;[[BR]] Comunidades_Autónomas: Nacional[[BR]] Actividad_principal: Total grupos CNAE93[[BR]] Estrato_de_asalariados: Total[[BR]] Unidades: Número de empresas;[[BR]] Notas: ( .. ) Dato no disponible;[[BR]] URL: http://www.ine.es/inebase/fic/px/l0/DIR_es_5.px;[[BR]] Origen: Instituto Nacional de Estadística;[[BR]] ')

It should answer

ERROR:  invalid byte sequence for encoding "UTF8": 0xc172
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

Change History (1)

comment:1 Changed 15 years ago by Víctor de Buen Remiro

Resolution: → fixed
Status: new → closed

(In [1926]) Fixed #833

Note: See TracTickets for help on using tickets.