Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#26 08-01-2017 07:51:11

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Garbled Foreign Characters

Yes, the only reason to use UTF-8 is to support customers who have non-US keyboards who may type non ISO-8859-1 characters.  But if you are running in ISO-8859-1 all the translation you're seeing should work.  Optimally everything should be in UTF-8, but something is not working right on your system.  I asked if you could copy the character from a known good source and try that rather than typing with your keyboard to see if there's a difference.  Is that possible?


Nick Hendler

Offline

 

#27 08-01-2017 12:57:18

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Garbled Foreign Characters

Yes, I have already done that using £ sign from https://www.w3schools.com/charsets/ref_ … lement.asp and got the same result. I am only using a regular version of Windows 10 with standard UK keyboard settings and a conventional Microsoft keyboard.

Last edited by sdn (08-01-2017 13:05:21)


Simon

Offline

 

#28 08-02-2017 08:24:50

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Garbled Foreign Characters

OK.  Thank you.  At this point I think we're well beyond what we can do on the forum, and you've gotten your hands dirty enough.  Somewhere in the mix there is something off in the configuration of PHP, MySQL and/or Apache, or the software (K9) needs to be updated to compensate.  I'd like to work with you to solve this.  I believe you have my direct email, please email me, or if you don't, please submit a basic ticket request and we'll get it underway there.  Thank you.


Nick Hendler

Offline

 

#29 08-02-2017 23:38:29

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Garbled Foreign Characters

OK, I have raised a support ticket.


Simon

Offline

 

#30 10-29-2021 07:50:18

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Garbled Foreign Characters

We never got a solution to the garbled foreign characters problem like Schloßstrasse becoming Schloßstrasse for a PayPal Express order. The same also happens on standard checkout where customer fills out the address fields.

If we manually update the address field in Order Manager using "Edit Order and Billing Info" it accepts and correctly retains the ß character without any problem.

Why can the database correctly store the character in that scenario but not the first?

Last edited by sdn (10-29-2021 07:52:12)


Simon

Offline

 

#31 11-24-2021 09:12:19

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Garbled Foreign Characters

Did the changes contained in update 9.0.2 (Oct 2017) do anything for you to help with this?

Modified HTML output and database encoding/charsets to explicitly set Latin1 (ISO-8859-1) as the default character set for output and data storage. Newer PHP versions are shipping with a UTF-8 default which causes some data presentation issues. Storage in ISO-8859-1 with translations to UTF-8 is the most portable solution and works as advertised in all instances.

Does your .htaccess file contain the following?

Code:

AddDefaultCharset Off

Nick Hendler

Offline

 

#32 11-24-2021 10:41:04

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Garbled Foreign Characters

The example "Schloßstrasse becoming Schloßstrasse" in post #30 above was a recent order using 9.03. We have "AddDefaultCharset Off" in htaccess just after the Gzip, Compress and Remove browser bug entries.


Simon

Offline

 

#33 03-14-2022 08:05:40

vanlisur
Member
Registered: 03-14-2022
Posts: 1

Re: Garbled Foreign Characters

forigen characters will work in UTF8 encoding. 

Last edited by vanlisur (03-15-2022 01:04:39)

Offline

 

#34 04-22-2022 08:34:22

gintibande
Member
Registered: 04-22-2022
Posts: 1

Re: Garbled Foreign Characters

Can we make these changes bu submitting raw SQL database statements in the management interface or does it need to be done by commandline shell? 

Last edited by gintibande (04-30-2022 01:42:40)

Offline

 

#35 04-25-2022 08:17:57

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Garbled Foreign Characters

These changes are done to the .htaccess file for the site, and in PHP config (php.ini).


Nick Hendler

Offline

 

#36 05-11-2022 06:35:26

ranjhhaheer
Member
Registered: 05-11-2022
Posts: 1

Re: Garbled Foreign Characters

Can we make these changes bu submitting raw SQL database statements in the management interface or does it need to be done by commandline shell?

Last edited by ranjhhaheer (05-13-2022 02:54:09)

Offline

 

#37 05-11-2022 08:17:47

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Garbled Foreign Characters

The .htaccess file cannot be edited from within the management interface.  You'll need to access it via the shell or FTP to make a change.


Nick Hendler

Offline

 

Board footer