PHP Firebird WIN1252 x UTF8

[elvispdosreis]

Dynamic SQL Error SQL error code = -303 Malformed string

I have a problem with php and firebird, where I have a database in firebird 2.5 with the charset WIN1252, and I have php making a connection through the interbase extension where the utf8 charset is defined to do the data transliteration between WIN1252 and UTF8, however when there is a parameter equal to null of error -303 in sql.
However testing by ibexpert does not give error.

select
from atividade a
inner join codigo_servicos c on c.cservcod = a.cservcod
where a.ativnome collate win_ptbr like '%limpe%'
      or c.cservcod = null
order by a.ativnome asc

[MartinKoeditz]

Hi,

please show me the DDL structure of your table (CREATE statement) and some data. Then I will be able to reproduce your problem.

Regards,
Martin

[elvispdosreis]

I'll set up an example of how to simulate Em qui., 7 de mai. de 2020 às 11:35, Martin Köditz <[email protected]> escreveu:

…

Hi, please show me the DDL structure of your table (CREATE statement) and some data. Then I will be able to reproduce your problem. Regards, Martin — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADUPOJ3FDEAAOKWMM3SXAWDRQLBJJANCNFSM4M3MCN3A> .

[MartinKoeditz]

Hi,

is this still a problem or could you fix it? Then I will close this issue.

Regards
Martin

[MartinKoeditz]

Seems to be no PHP related problem. I will close this issue. If there is still a problem, just open it again.