Hyphen en Valuta signs wrongly shown in Picklist

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-06-30 13:54

Hi,
Working with Version 26.13 Build: 2348

I get a remark that whenever a picklist is used the Hyphen and Valuta Signs are wrongly shown.
I didn't see that in former versions.
Could it depand on the General configuration?
02 Picklist -No Valutasign and Hyphen.png
02 Picklist -No Valutasign and Hyphen.png (15.29 KiB) Viewed 8364 times
01 Source Picklist Hyphen AND Valuta.png
01 Source Picklist Hyphen AND Valuta.png (44.61 KiB) Viewed 8364 times
03 General configuration.png
03 General configuration.png (48.87 KiB) Viewed 8364 times

User avatar
a.gneady
Site Admin
Posts:1381
Joined: 2012-09-27 14:46
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by a.gneady » 2026-08-20 16:35

Does this issue still happen in AppGini 26.14?
:geek: Build AppGini apps using Claude or other AI agents

:idea: AppGini plugins add more power to your apps -- Enjoy up to 30% off when buying 2 or more plugins.

:?: Need personalized consulting on your specific app and customizations? Book an online call with me here.

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-08-20 18:07

Hi,
Yes, when it is used in picklist.
I’m using 26.14
The maintable looks good

Ron

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by onoehring » 2026-09-01 08:05

Hi,

just stumbling over this.
Are you sure the encoding shown by Ahmed is indeed the one needed? - Just wondering.

Olaf

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-09-04 12:31

Hi OLaf,

Yes, I like to see the hyphens AND de Euro
Basetable-Pickist.png
Basetable-Pickist.png (26.34 KiB) Viewed 6510 times
Result-Pickist.png
Result-Pickist.png (41.25 KiB) Viewed 6510 times
sign back in the Picklist Result.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by onoehring » 2026-09-04 13:18

Hi Ron,

If I am not mistaken, you are shown browser images. I meant the encoding setting iin AG.

Olaf

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-09-04 13:41

Olaf,
Okay, misunderstanding sorry.
I've never changed the encoding settings. It's the same setting when I used 25.10 end higher

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by onoehring » 2026-09-05 09:05

Hi Ron,

maybe it's the underlying select2 that has changed (and breaks display)?
I suggest you take a look using F12 at the generated page. Is the correct UTF character encoded there? Does the browser encode the UTF character correct, if you simply put that into a single static html file?

Olaf

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts:1757
Joined: 2018-04-01 10:12

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by pbottcher » 2026-09-09 19:31

Hi Ron,

it may well be a problem with the encoding you are using. If I see correctly on the image, you are using a long hyphen, which does not exist in us ascii / western.
Maybe you can change you encoding and try again.

best
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by onoehring » 2026-09-10 05:25

Hi pboetcher,

I thought, he really wants that long hyphen (– or — , see https://www.w3schools.com/charsets/ref_ ... uation.asp ).
If this is NOT really needed, I suggest running a SQL to replace all such characters directly in the field of the table ... done (hopefully).

Olaf

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-09-10 11:13

Hi Olaf and Hi pboetcher,

The suggestion of changing the "long hyphen" worked (That was my mistake), however: De € sign is still not shown in the Picklist.
Ron

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by onoehring » 2026-09-10 12:25

Hi Ron,

maybe it's a problem with the select2.
However, assuming all prices in the list are Euros, why put the € maybe even as EUR in the header (or just the description of the field)?.
Of course, you could also consider replacing € with EUR.

Afterall, puttint € or EUR in every record does not add any additional information, this placing this information somewhere else would make a lot of sense to me.

Olaf

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-09-10 12:42

Hi Olaf,
I get it, however it is about pricing several services.
So there is a "service table" with 7 services and different prices with the €-sign.
Someone can pick a service and now the €-sign is not visible.
I could mention that prices are in Euro's, however it worked in former releases, this application runs now for 8 years.

So, if Select2 can't cope with the EUR sign, is this a "bug"?
Ron

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by onoehring » 2026-09-10 14:52

HI Ron,

running 8 year, I would doubt a bug in select2 then as I would think it's still a "tested" version.
Why not change € to EUR then?
If you have different currencies, I understand the need to show that. If you have only EUR, it may be easier .... (well hopefully this here solves the problem for all of us ;-)

Olaf

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts:1757
Joined: 2018-04-01 10:12

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by pbottcher » 2026-09-10 17:26

Hi Ron,

is there a reason to keep the encoding? If you change it to UTF-8 it will show both. See images.
UTF-8:
UTF-8.png
UTF-8.png (3.27 KiB) Viewed 5958 times
ASCII:
ASCII.png
ASCII.png (2.87 KiB) Viewed 5958 times
If you cannot change the encoding, Olaf is right, use EUR instead. Bet be aware the ASCII encoding has those limitations.

best
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Hyphen en Valuta signs wrongly shown in Picklist

Post by RonP » 2026-09-11 12:04

Hi pbottcher
Thank you for digging in .
There is no special need for using long hyphens, Somewhere my mistake.

About a month ago I had to reinstall Xampp etc and this Application.
For one reason the Character Encoding was set to US ASCII / Western
I've now changed this to: 4-byte Unicode UTF-8

This solves all my "problems"
Many thanks and Olaf as well!

Ron


Post Reply