Are you using a character set different from 'none' in your db? If so, it
seems your client is not using the same character set when connecting. Or
viceversa: your db is declared with 'none' (the default value) and your
client tries to connect with another one (iso8859_1 for example)

Ernesto Cullen

----- Original Message -----
From: "primusrm" <luciano@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, June 20, 2003 8:42 AM
Subject: [firebird-support] Select error


> 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
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>