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 notifications@github.com 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 https://github.com/FirebirdSQL/php-firebird/issues/1#issuecomment-625293077, 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.