Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Swedish Characters


altoid

Recommended Posts

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

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

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

@@altoid

Paypal module is bad or not well configured in paypal account.

:blink:
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

@@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) icon_info.gif 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

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

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

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

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)) . '&';
    }

:blink:
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

 

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...