NetTalk Central

Author Topic: Wrong encoding of text on maps  (Read 3080 times)

Poul Jensen

  • Full Member
  • ***
  • Posts: 224
    • View Profile
    • Email
Wrong encoding of text on maps
« on: March 13, 2025, 12:10:59 AM »
Hi,

In Webserver procedure, Webserver settings, General I have this to correctly work with the tables in the database that is shared with a desktop app:
Charset: utf-8
Store data as: Scandinavian (windows 1252)

But on the map, the tooltip text is wrong.  See attached image.

The table containing the points are dynamically filled, so I thought I could encode the textfield there, so it would show properly.  But no luck so far.

Any ideas most welcome.

tia
/Poul

Poul Jensen

  • Full Member
  • ***
  • Posts: 224
    • View Profile
    • Email
Re: Wrong encoding of text on maps
« Reply #1 on: March 15, 2025, 12:03:21 AM »
Found a workaround - not the final one I hope, because I change the Danish characters to double characters.  Looks a bit nicer but still....

In the embed "Set Map Data Options" I change the characters using Stringtheory search/replace and then call:

p_web.SetOption(loc:options,'title',CLIP(Mmap:Tekst))


Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11296
    • View Profile
Re: Wrong encoding of text on maps
« Reply #2 on: March 17, 2025, 06:03:40 AM »
>> The table containing the points are dynamically filled

filled from the database? or from something else?

Poul Jensen

  • Full Member
  • ***
  • Posts: 224
    • View Profile
    • Email
Re: Wrong encoding of text on maps
« Reply #3 on: March 17, 2025, 06:46:14 AM »
Hi Bruce,

The points table are being filled from data in the job-card table:
lat/lon and the text shown is various data related to the job and the customer.

Cheers
/Poul

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11296
    • View Profile
Re: Wrong encoding of text on maps
« Reply #4 on: March 18, 2025, 02:26:05 AM »
Is the database TPS?
I think I will need an example showing the effect.
Specifically I want to see where the encoding is happening - and what is in the database to start with.

Cheers
Bruce

Poul Jensen

  • Full Member
  • ***
  • Posts: 224
    • View Profile
    • Email
Re: Wrong encoding of text on maps
« Reply #5 on: March 18, 2025, 01:24:33 PM »
Hi Bruce,

I have emailed an example app.

Cheers
/Poul

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11296
    • View Profile
Re: Wrong encoding of text on maps
« Reply #6 on: March 24, 2025, 11:43:24 PM »
thanks - fixed for 14.30

Poul Jensen

  • Full Member
  • ***
  • Posts: 224
    • View Profile
    • Email
Re: Wrong encoding of text on maps
« Reply #7 on: March 27, 2025, 12:05:18 PM »
Have now testet NT 14.30 - and this issue is resolved.

Thanks.

/Poul

Poul Jensen

  • Full Member
  • ***
  • Posts: 224
    • View Profile
    • Email
Re: Wrong encoding of text on maps
« Reply #8 on: March 29, 2025, 02:06:31 AM »
Just a minor issue:

Encoding is correct when you hover over a point/marker.
If you click the marker and go to the update form, when you the return to the map the encoding is wrong again on that marker.  Tips on other markers are still good.