• Jobs
  • About Us
  • professionals
    • Home
    • Jobs
    • Courses and challenges
  • business
    • Home
    • Post vacancy
    • Our process
    • Pricing
    • Assessments
    • Payroll
    • Blog
    • Sales
    • Salary Calculator

0

169
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?

about 3 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 Our process Sales
Legal
Terms and conditions Privacy policy
© 2025 PeakU Inc. All Rights Reserved.

Andres GPT

Recommend me some offers
I have an error