new_x

When I dumped the data using pgAdmin4 it is correctly stored and when I used select statement in Delphi to get the data from table, it successfully gets the data correctly.

To check for DB "Monitor", I used the following SQL statement, SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = 'Monitor'; Result is; UTF8

It is seemed to be something from FireDAC, since the same data can be inserted correctly within pgAdmin4 by using SQL insert statement. Anyway I will use TSQLMonitor. Thanks your suggestion

I used the following query from pgAdmin4 SHOW SERVER_ENCODING; The result is; "UTF8"

I use parameters, thank you

Although DB encoding is UTF8, the characters are not stored correctly from Delphi application. But If I insert the data from pgAdmin4 they are correctly stored. So the DB Encoding is UTF8

There is no option in TFDConnection character set for "ISO-8859-9 or Windows-1254"

It is UTF 8

Hi I am using Delphi 11 Community Version, designed a DB in PostGreSQL and created a table, this table has a QuizAnswers" columns of type text, Created a Delphi Application having a memo into which user writes his own answer to the Quiz questions, I want to store user answer (which is entered into the memo) into the column "QuizAnswers" , The answers are in Turkish and may have non-standard characters like "ğ", "ç", "ü", "ı", "o".., I am using FireDAC FDCOnnection, FDPhysPgDriverLink, FDQuery and the final result is that these non-standard characters are not stored in their original form, instead "ğ" is stored as "g", "ç" is stored as "c" , "ö" is stored as "o" so on. I used the pgAdmin4 to store the same string consisting these Unicode Characters into the same column, all characters are stored and displayed correctly. Regards,

Thank you for kind reply. Just to explain further. In fact I am required to develop a web service to put data into learning platform Moodle. The data (student ID, number etc.) should be read in GUI (edit boxes) or from a postgresql db and must be inserted into Moodle platform. I will look into DMVCFramework . thank you

I am trying to learn to write a Delphi REST Web Service program (both the server and the client side). Currently my platform is Delphi 11 Community Edition supporting Internet Direct (Indy) 10.6.20. I searched through the Internet have not found sample codes or explanations. All I found is some videos using DataSnap project but In delphi 11 I could not Find File->New->Other->Data Snap. The only option is “Soap Server Application”. If my current version of Delphi does not support REST, Could you then provide SOAP based (server and client) source code and explanation. Since I am newbie, could anyone share source code and explanations. Thanks in advance

Hi Peter, That is very nice to contact a person from Team-B, regards, and thank you for your comment.

Thank you Lajos, by the way for the second part of my question ("are all the codes/packages listed in GetIt safe to use") do you have any idea? Regards

Hi all, I planned to use AES encryption in a project. I searched and found that there are some packages available as third party available via GetIt. (No native support in Delphi for encryption/decryption). I returned to Delphi after several years (The last version I used was D7). My question is "Is every package listed in GetIt safe to use", the second question is "is there any package that you suggest" thank you in advance.

Thanks all of you for your comments.