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?

Image

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.

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.

Image

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.