character encoding

[espo]

Hello to all.
I have a problem with the character encoding. When I try to insert a note (text), if I enter characters with accents (for example à) the note remains empty after saving.
Which encoding should I enter to make it work? I currently use in Localization Settings "Western" and in the Default Project "Unicode and UTF-8"

Can you help me?
Thank you very much.

[AhmedBR]

I use phpMyAdmin and change the Collation of the table to: latin1_swedish_ci

Works fine here with all of these letters ô é ã etc.

[espo]

If I try to insert in phpmyadmin latin1_swedish_ci does not work.
In the program AppGini which encoding should I use? If I leave Western special characters (à, ò, etc..) Does not accept them and I leave the text field empty.
If I insert in AppGini Unicode UTF-8 special characters (à, ò, €, etc.) Will be accepted but does not see the date format Currenty Euro (€ 21.123,56) in the table.

How can I fix?
Can anyone help me?

[espo]

Hello,

no one has a solution to this problem?

[espo]

I wanted to specify that the numeric field is formatted in DECIMAL, Lenght 20, Precision 2 and Euro Currency format.

Posting Date Format from AppGini in the table, the field remains empty, while I see the details in the table field (eg 400.00).
If I was using the character encoding WESTERN but I had no problems using UNICODE UTF-8 I have this problem.

How can you solve?

[pgkounelas]

1. in database chose utf_general_ci
2. in AppGini in field "character encoding" chose "unicode utf" and generate the aplication

[espo]

I entered what I've written but what I see is this.

The question mark in front of numbers should be the symbol of the euro.

What could be wrong?

[pgkounelas]

Open the file table_view.php with Notepad++ and change the ANSI encoding to UTF WITHOUT BOM

[espo]

Hello,

I'm sorry but the file that you have indicated there is no ANSI string.

Unfortunately, the problem remains.
You can solve it, you know?

[pgkounelas]

To help you should send me all files in .zip file with .axp file
Do this with a link in your message

[a.gneady]

Try this: In the folder where AppGini is installed, typically C:\Program Files(x86), open the subfolder "add-ons" then open the file "dataFormats.cfg" in a text editor ... change the second line to read:

Code: Select all

Euro Currency (example: €21,345.67); CONCAT('€', FORMAT(%%FIELD%%, 2))

That is, change the second euro symbol (but not the first one) to '€'

If this works, kindly let me know to fix it in the next release.

[espo]

Hello Ahmad,

so it works.

I insert the image.



Thank you very much.

[espo]

Hello Ahmad,

But there is a problem. If I insert the character READ ONLY € so you can see the detail page.

[a.gneady]

OK, I'll try to fix this issue, including the detail view read-only problem, in the next release -- due this month.