Recent

Author Topic: Strings converson between Oracle 9 and Firebird 3.1 on Windows 2016 Server  (Read 518 times)

krzynio

  • Full Member
  • ***
  • Posts: 109
    • Krzynio's home page
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][+][-]
  1. SELECT 'K' AS ko FROM oraTable
Then I prepare query (qf) for Firebird server using
Code: Pascal  [Select][+][-]
  1.  qf.SQL.Add('update fbTable set kf='''+qo.FieldByName('ko').AsString+'''');
Then result is:
Code: SQL  [Select][+][-]
  1. 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.
Debian 12.8 x64, / Windows 11 PL - latest updates
Lazarus 3.6

Thaddy

  • Hero Member
  • *****
  • Posts: 16520
  • Kallstadt seems a good place to evict Trump to.
That is another Firebird issue.
But I am sure they don't want the Trumps back...

 

TinyPortal © 2005-2018