Page 1 of 1
character encoding
Posted: 2013-09-26 16:12
by 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.
Re: character encoding
Posted: 2013-09-26 18:44
by AhmedBR
I use phpMyAdmin and change the Collation of the table to: latin1_swedish_ci
Works fine here with all of these letters ô é ã etc.
Re: character encoding
Posted: 2013-09-27 08:12
by 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?
Re: character encoding
Posted: 2013-09-30 07:17
by espo
Hello,
no one has a solution to this problem?
Re: character encoding
Posted: 2013-09-30 09:27
by 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?
Re: character encoding
Posted: 2013-09-30 16:23
by pgkounelas
1. in database chose utf_general_ci
2. in AppGini in field "character encoding" chose "unicode utf" and generate the aplication
Re: character encoding
Posted: 2013-10-01 13:10
by 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?

Re: character encoding
Posted: 2013-10-01 14:54
by pgkounelas
Open the file table_view.php with Notepad++ and change the ANSI encoding to UTF WITHOUT BOM
Re: character encoding
Posted: 2013-10-02 08:33
by 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?
Re: character encoding
Posted: 2013-10-02 18:59
by pgkounelas
To help you should send me all files in .zip file with .axp file
Do this with a link in your message
Re: character encoding
Posted: 2013-10-12 14:28
by 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.
Re: character encoding
Posted: 2013-10-14 09:23
by espo
Hello Ahmad,
so it works.
I insert the image.
Thank you very much.
Re: character encoding
Posted: 2013-10-14 09:36
by espo
Hello Ahmad,
But there is a problem. If I insert the character READ ONLY € so you can see the detail page.

Re: character encoding
Posted: 2013-10-14 23:23
by a.gneady
OK, I'll try to fix this issue, including the detail view read-only problem, in the next release -- due this month.