MYSQL/ODBC Unreadable values
lazarus / 16-Databases

----------------------------------------------------------------------
Svaty · 2024-10-29 16:01

Hi

Some time i try to find solution on problem with return values from
mysql.

I have problem with ONLY TEXT,TINYTEXT,MEDIUMTEXT,.... These datatypes
on culumns return wrong values(attached file from lazarus local
variables). But there is no problem with another datatypes. Only
solution what i found is CAST in mysql query.

Does somebody have another solution please??

MYSQL ODBC 8.3 unicode
MYSQL SERVER 8.4
Lazarus 3.0(3.2.2)

----------------------------------------------------------------------
paweld · 2024-10-29 17:39

The values are ok, only they are encoded in UTF16. You need to convert
them to UTF8 using the UTF16ToUTF8 or UTF8Decode function from the
LazUTF8 unit. ie.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i uses 
LazUTF8;    var  s: String;begin  s :=
UTF16ToUTF8(dataset.Fields[0].Text);  //...end;