♥altoid Posted February 17, 2017 Share Posted February 17, 2017 For a customer from Sweden, in his customer information address line it shows this: Bivackgränden 21 But in the address line in his shipping information shows this: Bivackgränden 21 Any ideas what's going on there? Thanks I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
MrPhil Posted February 17, 2017 Share Posted February 17, 2017 The address appears to have been entered in UTF-8 encoding (two bytes for the ä character). For some reason, the shipping information is displaying in Latin-1 or CP-1252, or some similar single byte encoding, and you see two separate characters. What osC version? Is the database consistently Latin-1 or (better) UTF-8? Is it showing up as Latin-1 on any web page, or on a printout, or only in an email, or where? That might give a clue as to who is responsible for showing text with the wrong encoding. Link to comment Share on other sites More sharing options...
mcmannehan Posted February 18, 2017 Share Posted February 18, 2017 Try to do this:Go to Tools -> Database Tables select all. In the dropdown select "convert to UTF8" and click "Go" And check the setlocale in your languages file (/catalog/includes/languages/swedish.php The clever one learn from everything and from everybody The normal one learn from his experience The silly one knows everything better [socrates, 412 before Christ] Computers help us with the problems we wouldn't have without them! 99.9% of the bugs sit in front of the computer! My programmed add-ons: WDW EasyTabs 1.0.3, WDW Facebook Like 1.0.0 if(isset($this) || !isset($this)){ // that's the question... Link to comment Share on other sites More sharing options...
tgely Posted February 18, 2017 Share Posted February 18, 2017 @@altoidPaypal module is bad or not well configured in paypal account. osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
♥altoid Posted February 18, 2017 Author Share Posted February 18, 2017 @@MrPhil @@mcmannehan @@Gergely Morning and thanks for the responses. Here is some info in response. Info: Version 2.3.4 BS (about 3/4 along the way from Gold to Edge) All table collation was and is utf8_unicode_ci Checking in table_orders I see for this customer customers_street_address: Bivackgränden 21 delivery_street_address: Bivackgränden 21 The customers customers_address_format_id is 1 Now looking at other format ids I see they seem to change from country to country. In my database table, it seems all the "1s" are mostly non US english speaking countries, but I do see Russia and Norway in there too. Page Source for some ON index page it is: charset="utf-8" on account.php it is: charset="utf-8" for address_book_process.php it is charset="utf-8" I only have English language activated on this shop. This situation is viewable to me on the admin side in orders.php and apparently is carried over to PayPal where in the payment notice I see the character situation in the shipping address. I have not yet install the PP App on this shop. I am using the stock PP Express module. Version: 3.0 (online status) API Version: 112 Thanks I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
MrPhil Posted February 18, 2017 Share Posted February 18, 2017 Check that the English language module isn't overriding your selected character encoding (although that would likely change everything to Latin-1 display). Check that each field is UTF-8, and no field (especially the delivery street address) is still Latin-1. The data in the field is UTF-8, but somewhere along the line something is treating it as Latin-1. Link to comment Share on other sites More sharing options...
mcmannehan Posted February 18, 2017 Share Posted February 18, 2017 okay: one idea more: check if the languages file saved in utf-8 without boom if so, than i agree with Gergely -> Paypal module is bad or not well configured in paypal account. i recommand, install the new Paypal app The clever one learn from everything and from everybody The normal one learn from his experience The silly one knows everything better [socrates, 412 before Christ] Computers help us with the problems we wouldn't have without them! 99.9% of the bugs sit in front of the computer! My programmed add-ons: WDW EasyTabs 1.0.3, WDW Facebook Like 1.0.0 if(isset($this) || !isset($this)){ // that's the question... Link to comment Share on other sites More sharing options...
♥altoid Posted February 18, 2017 Author Share Posted February 18, 2017 cannot find anything other than UTF-8 in tables and/or appropriate files. I'll look at PP configuration and if nothing shows there...work on the PP app install. Thanks I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
tgely Posted February 19, 2017 Share Posted February 19, 2017 Probably PP response is not utf8 or not well converted in PP module. There are no correct official app for this problem... Issue report: http://www.oscommerce.com/forums/tracker/issue-1218-paypal-app-express-checkout/Similar codes are missing from codebase: parse_str(utf8_decode($response), $response_array); //This function automatically urldecodes values (not mentioned in the docs). foreach ( $params as $key => $value ) { $post_string .= $key . '=' . urlencode(trim($value)) . '&'; } osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
mcmannehan Posted February 19, 2017 Share Posted February 19, 2017 Probably PP response is not utf8 or not well converted in PP module. There are no correct official app for this problem... Issue report: http://www.oscommerce.com/forums/tracker/issue-1218-paypal-app-express-checkout/ Similar codes are missing from codebase: parse_str(utf8_decode($response), $response_array); //This function automatically urldecodes values (not mentioned in the docs). foreach ( $params as $key => $value ) { $post_string .= $key . '=' . urlencode(trim($value)) . '&'; } utf8_decode does not work in this case This function decodes data, assumed to be UTF-8 encoded, to ISO-8859-1. The clever one learn from everything and from everybody The normal one learn from his experience The silly one knows everything better [socrates, 412 before Christ] Computers help us with the problems we wouldn't have without them! 99.9% of the bugs sit in front of the computer! My programmed add-ons: WDW EasyTabs 1.0.3, WDW Facebook Like 1.0.0 if(isset($this) || !isset($this)){ // that's the question... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.