Strings converson between Oracle 9 and Firebird 3.1 on Windows 2016
Server
lazarus / 16-Databases

----------------------------------------------------------------------
krzynio · 2024-06-26 12:08

I had a program that works fine compiled on Lazarus 2.2, Zeos 7.14
taht works fine on Windows 2012 Server
The same program doesn't work on Windows 2022 Server.

I get result of the query 9 (qo) from Oracle i.e.:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT 'K'
AS ko FROM oraTableThen I prepare query (qf) for Firebird server using
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
 qf.SQL.Add('update fbTable set
kf='''+qo.FieldByName('ko').AsString+'''');Then result is:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i UPDATE
fbTable SET kf='K   'I am expecting 'K' but I receive 'K   '.  kf is
type of char(2) so I receive overflof error because my new kf is not
'K' but 'K   ' 4 chracters long.
How to fix it?
Code page set in connection setings is UTF8.

----------------------------------------------------------------------
Thaddy · 2024-06-26 12:15

That is another Firebird issue.