Welcome, Guest
Username: Password: Remember me
CodeTyphon Linux OS Development, discussions and problems
  • Page:
  • 1

TOPIC:

problems with the German special characters 3 years 11 months ago #14722

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 1
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!

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

problems with the German special characters 3 years 11 months ago #14723

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Away
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4512
  • Thank you received: 1101
Please Sir
update to 7.10
PilotLogic Architect and Core Programmer

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

problems with the German special characters 3 years 11 months ago #14724

  • Jan Roza
  • Jan Roza's Avatar
  • Away
  • Junior Member
  • Junior Member
  • Posts: 158
  • Thank you received: 6
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), virtual Linux Mint (64-bit) and virtual Raspberry Pi Desktop

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

problems with the German special characters 3 years 11 months ago #14725

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 1
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.

problems with the German special characters 3 years 11 months ago #14726

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 1
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.

problems with the German special characters 3 years 11 months ago #14727

  • Jan Roza
  • Jan Roza's Avatar
  • Away
  • Junior Member
  • Junior Member
  • Posts: 158
  • Thank you received: 6
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), virtual Linux Mint (64-bit) and virtual Raspberry Pi Desktop

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

problems with the German special characters 3 years 11 months ago #14728

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 1
I work in the virtual box with Lazarus and things are going well there.



There is also more choice under Lazarus

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

problems with the German special characters 3 years 11 months ago #14729

  • Jan Roza
  • Jan Roza's Avatar
  • Away
  • Junior Member
  • Junior Member
  • Posts: 158
  • Thank you received: 6
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), virtual Linux Mint (64-bit) and virtual Raspberry Pi Desktop

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

problems with the German special characters 3 years 11 months ago #14730

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 1
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.

problems with the German special characters 3 years 11 months ago #14731

  • Jan Roza
  • Jan Roza's Avatar
  • Away
  • Junior Member
  • Junior Member
  • Posts: 158
  • Thank you received: 6
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), virtual Linux Mint (64-bit) and virtual Raspberry Pi Desktop
The following user(s) said Thank You: bibsi

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

problems with the German special characters 3 years 11 months ago #14733

  • bibsi
  • bibsi's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 1
Thank you for paying attention to me

:-)

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

problems with the German special characters 3 years 11 months ago #14734

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Away
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4512
  • Thank you received: 1101
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
The following user(s) said Thank You: bibsi

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

Last edit: by Sternas Stefanos.
  • Page:
  • 1