× CodeTyphon Linux OS Development, discussions and problems

Question problems with the German special characters

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14722 by bibsi
Hello everybody

I've been a CodeTyphon user for a few months
and its version 6.7 I have problems with the German special characters ÖöÄäÜü
Can you help me with this?
A screen image as an attachment
Thank you!
Attachments:

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
1 month 2 weeks ago #14723 by Sternas Stefanos
Replied by Sternas Stefanos on topic problems with the German special characters
Please Sir
update to 7.10

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14724 by Jan Roza
Replied by Jan Roza on topic problems with the German special characters
I think it is more a database problem than a Codetyphon problem, the dbgrid just shows what is in the database.
Might be interesting to know what database is used.

Operating Systems Windows 10 (64-bit) and virtual Linux Mint (64-bit)

Please Log in or Create an account to join the conversation.

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14725 by bibsi
Thank you for your prompt reply.

I've already done it but it didn't help :-(

Please Log in or Create an account to join the conversation.

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14726 by bibsi
No windows
Linux Mint 19.3 Cinnamon 4.4.8
Linux kernel 5.3.0-51-generic
Database Firebird 3.0 runs on Rasperry Pi

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14727 by Jan Roza
Replied by Jan Roza on topic problems with the German special characters
Have you looked in the database with a database manager to check that the values in the database do contain those special characters.
If they are already wrong in the database then it is a problem with the program that added the data to the database.
I am not familiar with Firebird but isn't there a language codepage setting you can set in one of the database parameters in the connection?

Operating Systems Windows 10 (64-bit) and virtual Linux Mint (64-bit)

Please Log in or Create an account to join the conversation.

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14728 by bibsi
I work in the virtual box with Lazarus and things are going well there.



There is also more choice under Lazarus

Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14729 by Jan Roza
Replied by Jan Roza on topic problems with the German special characters
I'm not very familiar with firebird and codepages but you could experiment with them to see if it makes any difference.
But to make sure you are not hunting ghosts, first look in the database itself if the character are correct there.

Operating Systems Windows 10 (64-bit) and virtual Linux Mint (64-bit)

Please Log in or Create an account to join the conversation.

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14730 by bibsi
I have been using the database since 2000. I started working with Interbase and Delphi 4.
Then I switched to Firebird 1.5, 2.0 and 2.5. The database is still in use with a program under a VirtualBox with Windows XP that I wrote with Delphi 7.
At the moment I am trying to convert the application to Linux.
Since I write the application in parallel with Lazarus and always access the same database, I see no problem with the database. Lazarus installed the zeosdbo-7.2.6.1-stable package, and I have no problem there. But I would like to use CodeTyphon because the shape designer is better solved here. I think the integration of zeosdbo makes a problem. But I don't know my way around :-)

Wishing a nice evening.


Please report any errors in the text to Google Translation. ;-)

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14731 by Jan Roza
Replied by Jan Roza on topic problems with the German special characters
If you have no problem with Lazarus then I suspect that the zeos package Codetyphon uses is different than the Lazarus zeos component.
In that it is better that the guys from Codetyphon take a look.
Sorry I can't be of more help.

Operating Systems Windows 10 (64-bit) and virtual Linux Mint (64-bit)
The following user(s) said Thank You: bibsi

Please Log in or Create an account to join the conversation.

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14733 by bibsi
Thank you for paying attention to me

:-)

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
1 month 2 weeks ago - 1 month 2 weeks ago #14734 by Sternas Stefanos
Replied by Sternas Stefanos on topic problems with the German special characters
Sir
CT use the latest SVN/GIT/HG source for CT packages.
For sample pl_ZeosDBO in CT 7.10 use source from Zeos trunk SVN Rev : 6416 more info

codetyphon\typhon\components\pl_ZeosDBO\source\component\ZDatasetUtils.pas line 77
has only
  {** Defines the Target Ansi codepages for the Controls }
  TZControlsCodePage = ({$IFDEF UNICODE}cCP_UTF16, cCP_UTF8, cGET_ACP{$ELSE}{$IFDEF FPC}cCP_UTF8, cCP_UTF16, cGET_ACP{$ELSE}cGET_ACP, cCP_UTF8, cCP_UTF16{$ENDIF}{$ENDIF});

My suggestion is to try if ClientCodePage property work for you.
else
convert your database codePage and test.

PilotLogic Architect and Core Programmer
Last edit: 1 month 2 weeks ago by Sternas Stefanos.
The following user(s) said Thank You: bibsi

Please Log in or Create an account to join the conversation.