Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

207
Views
Malformed SQL string in Firebird with Laravel

I am working currently on a Laravel (Laravel version: 5.1.46 (LTS), PHP version: PHP 7.0.13) application that uses Firebird for database. I use iconv() to convert UTF-8 strings into Windows-1250 to save a record. Since about 2 days it stopped working.

iconv('UTF-8', 'WINDOWS-1250', 'ékezet');

This is the code I use to convert it and than pass it to the following SQL query:

\DB::select(\DB::raw("UPDATE CIKK_LEIRASOK SET LEIRAS = '$leiras' WHERE VONALKOD = " . $product->VONALKOD));

But something went wrong and I get the following error:

SQLSTATE[HY000]: General error: -104 Dynamic SQL Error SQL error code = -104 Malformed string (SQL: UPDATE CIKK_LEIRASOK SET LEIRAS = ' ?kezet ' WHERE VONALKOD = 1)

I googled about it but couldn't find anything and I have no clue what could be wrong.

Anyone more experienced in this subject?

over 4 years ago · Santiago Trujillo
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!