Hi,

The following (sequencia_paramper = 3) is gettin an error: "Cannot
transliterate character between character sets"

If I remove this part, the select works whithot error.
The field 'sequencia_paramper' is a smallint type.
The ones 'periodoano_matr' and 'periodoano_paramper' are Char(6).
The entire select is below:

select id_aluno, nome_aluno, cod_matr, linhacron_matr, periodoano_matr
from aluno
left join matricula
on idaluno_matr = id_aluno
join param_per
on (periodoano_paramper = periodoano_matr)
where (periodoano_matr <> '3/2003') and
(sequencia_paramper = 3)

I moved the "bad" part from select to join without success.

What could be wrong??

Best regards

Luciano RM
Programador - Igarapava-SP