Strange encoding problem

[daniellek]

I've been using zencart for some years, now I'd like to setup new shop which should be non-english.
I've made copy of files and installed it in new database.
While adding categories/products I got question marks instead of national letters.
Easy thing - db is probably latin1 and it was - I've converted it to utf-8.
Now I can add and see national letters in admin, but still get junk in public store.

Charset is also set to utf8. Any ideas?

You can check it out on: http://kreatywne.wrota.net/sklep/

$ grep -r define.*CHARSET -r .|less
./includes/dist-configure.php:define('DB_CHARSET', 'utf8');
./includes/classes/db/mysql/query_factory.php:    if (defined('DB_CHARSET')) $dbCharset = DB_CHARSET;
./includes/configure.php:  define('DB_CHARSET', 'utf8');
./includes/functions/functions_email.php:      $mail->CharSet =  (defined('CHARSET')) ? CHARSET : "iso-8859-1";
./includes/languages/english.php:  define('CHARSET', 'utf-8');
....

[kobra]

/includes/languages/english.php: define('CHARSET', 'utf-8');

What language is this???
Do you have a folder and english.php file re-named to that language loaded?

https://www.zen-cart.com/content.php...-are-they-used

[daniellek]

For now I'm using english.php language.
First of all I'm trying to get database charset working.
You can see the problem when you look at categories, last one should say RÓŻNOŚCI: http://kreatywne.wrota.net/sklep/index.php

[daniellek]

Here's how it looks in admin:

[kobra]

Use phpmyadmin to determine what collation your DB is and what collation your tables are
They should both/all be utf-8

[daniellek]

Use phpmyadmin to determine what collation your DB is and what collation your tables are
They should both/all be utf-8

I converted DB and all the tables to utf-8, example from categories:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Baza danych: `kreatywne_sklep`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `categories_description`
--

CREATE TABLE IF NOT EXISTS `categories_description` (
  `categories_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '1',
  `categories_name` varchar(32) NOT NULL DEFAULT '',
  `categories_description` mediumtext NOT NULL,
  PRIMARY KEY (`categories_id`,`language_id`),
  KEY `idx_categories_name_zen` (`categories_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Zrzut danych tabeli `categories_description`
--

INSERT INTO `categories_description` (`categories_id`, `language_id`, `categories_name`, `categories_description`) VALUES
(16, 1, 'Różności', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[kobra]

What do you see in phpmyadmin for collation

[lat9]

Look in your primary language files, assuming at this point that you're using english.php for both the admin and store-front. I think that the issue is the PHP locales that are being used.

In the as-shipped Zen Cart /includes/languages/english.php file, that setting looks like

// look in your $PATH_LOCALE/locale directory for available locales..
  $locales = array('en_US', 'en_US.utf8', 'en', 'English_United States.1252');
  @setlocale(LC_TIME, $locales);

If you haven't changed those settings for your language, that's most likely the source of your issue. Since the information displays properly in the admin, see what the similar settings are for the /YOUR_ADMIN/includes/languages/english.php file and use those values for the store.

[daniellek]

What do you see in phpmyadmin for collation

utf8_general_ci

[daniellek]

Look in your primary language files, assuming at this point that you're using english.php for both the admin and store-front. I think that the issue is the PHP locales that are being used.

It's en_US.utf8. I've tried changing it to pl_PL.utf8 - but it didn't change anything (utf8 is the same in english and polish ;-)

includes/languages/english.php:// look in your $PATH_LOCALE/locale directory for available locales..
includes/languages/english.php:  $locales = array('en_US', 'en_US.utf8', 'en', 'English_United States.1252');
includes/languages/english.php:  @setlocale(LC_TIME, $locales);

xxx/includes/languages/english.php:// look in your $PATH_LOCALE/locale directory for available locales..
xxx/includes/languages/english.php:$locales = array('en_US', 'en_US.utf8', 'en', 'English_United States.1252');
xxx/includes/languages/english.php:@setlocale(LC_TIME, $locales);