Recent

Author Topic: FirebirdSQL Win1250 question  (Read 849 times)

k1attila1

  • Jr. Member
  • **
  • Posts: 82
FirebirdSQL Win1250 question
« on: February 16, 2019, 07:12:35 pm »
Hi

I try to use in my application FB2.5 with win1250 cp.

But in dbedit i have problem.
When i type the text everything is OK, but when i leave the dbedit something go wrong.
See attachments.

Any idea ? What is wrong ?



Zoran

  • Hero Member
  • *****
  • Posts: 1389
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: FirebirdSQL Win1250 question
« Reply #1 on: February 16, 2019, 08:10:11 pm »
In Object inspector set CharSet property of the IBConnection to UTF8.

Yes, to UTF8, not to Win1250 - this will tell your db server what charset the client uses, and in Lazarus applications it is UTF8.
« Last Edit: February 16, 2019, 08:16:11 pm by Zoran »

k1attila1

  • Jr. Member
  • **
  • Posts: 82
Re: FirebirdSQL Win1250 question
« Reply #2 on: February 16, 2019, 09:26:08 pm »
Sorry, i forgot to mention.
i use Zeos.

Zoran

  • Hero Member
  • *****
  • Posts: 1389
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: FirebirdSQL Win1250 question
« Reply #3 on: February 16, 2019, 11:27:30 pm »
In Zeos 2.5 there are properties ClientCodepage and ControlsCodePage. First, make sure that ControlsCodePage is set to cCP_UTF8, and set ClientCodePage to UTF8.

If you have older version update - please use 7.2-pathces branch:
https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/branches/7.2-patches/