Page 2 of 2

Re: Template modification with polish charset - entities ?

Posted: Fri 13. Mar 2009, 16:04
by dellos
The settings:
$phpwcms['db_charset'] = 'utf8';
$phpwcms['db_collation'] = 'utf8_general_ci';
$phpwcms['charset'] = 'iso-8859-2';

Worked well for 1.2.6 so why it shouldn't work for 1.4.1 ?? The polish charset is iso-8859-2 not utf8. The coding utf_general_ci is for most languages and it's I think standard for MySQL database's.

I'm giving screen for settings wrote before, later I will ad also the iso-8859-2 changed to utf8
http://chomikuj.pl/dellos/Dokumenty/iso_8859_2.jpg

Re: Template modification with polish charset - entities ?

Posted: Fri 13. Mar 2009, 16:40
by dellos
The settings2:
$phpwcms['db_charset'] = 'utf8';
$phpwcms['db_collation'] = 'utf8_general_ci';
$phpwcms['charset'] = 'utf8;

And now the screen from setting's 2. The backend of panel has no Polish letters. And dooing feeding from let say phpBB2 on page gives no Polish letters. The phpBB work's fine on iso-8859-2 and the feed is in that coding. The phpwcms in 1.2.6 working fine wyth charset=iso-8859-2. The write coding for Polish is iso... not utf8. So if something worked in 1.2.6 wyth no problems for years that there is bug in 1.4.1 if it's not working as used to...

http://chomikuj.pl/dellos/Dokumenty/utf8.jpg

Do you want the Config File here ?? or something ??

Re: Template modification with polish charset - entities ?

Posted: Sat 14. Mar 2009, 08:47
by Oliver Georgi
No, just put some polish letters here - I will check.

Oliver

Re: Template modification with polish charset - entities ?

Posted: Sat 14. Mar 2009, 12:44
by flip-flop
I am running a site with a polish environment and all is running well: V1.4.1 r305

If I insert polish letters like s'c' (ALT-s ALT-c) the frontend output is very crappy. -> ¶æ

The right entities are ść but the system generates ¶æ

No Update, filling up a new installation.
$phpwcms['db_charset'] = 'latin2';
$phpwcms['db_collation'] = 'latin2_general_ci';

$phpwcms['charset'] = 'iso-8859-2';
I think, we can´t use different charsets in front- and backend.
There we have no chance to use the polish iso-8859-2 charset.

Mhh, backend is running two with iso-8859-2.

The interpretation of polish chars during save isn´t right. (Text fields like form and so on). Wysiwyg is running well.

Knut

Re: Template modification with polish charset - entities ?

Posted: Sun 15. Mar 2009, 20:21
by dellos
Yes, krzychb shown that in older version he also didn't have problem. I worked, till I think 1.2.7 or 1.2.6 and worked ok for UTF8 and iso-8859-2. The problem showed, when to Config file the [charset] was add'ed. For me it's a bug and the phpwcms is not for PL usage. Lat's say that You doing some Multilanguage site, the coding in Latin2 is't the best sollution for db, the UTF8 will be. And on my hosting I have to use UTF8 not Latin2, so latin is't the good choice for me.

I must work on:
$phpwcms['db_charset'] = 'utf8';
$phpwcms['db_collation'] = 'utf8_general_ci';
$phpwcms['charset'] = 'iso-8859-2';

for being compatible wyth PL language.

Re: Template modification with polish charset - entities ?

Posted: Mon 16. Mar 2009, 00:40
by Oliver Georgi
I have checked:

$phpwcms['db_charset'] = 'utf8';
$phpwcms['db_collation'] = 'utf8_general_ci';
$phpwcms['charset'] = 'utf-8';

Do NOT!!!! mix charsets! Always recommend to use UTF-8 or ISO8859-1. All others might be problematic. Check also what charset is your PHP set by default!

As far I could check there is NO UTF-8 problem in frontend nor backend - no difference when updating such content:
Frontend
Frontend
2009-03-16_000524.png (26.67 KiB) Viewed 1512 times
2009-03-16_000607.png
2009-03-16_000607.png (8.32 KiB) Viewed 1512 times
2009-03-16_000616.png
2009-03-16_000616.png (5.85 KiB) Viewed 1512 times
2009-03-16_000625.png
2009-03-16_000625.png (3.91 KiB) Viewed 1513 times
2009-03-16_000821.png
2009-03-16_000821.png (3.47 KiB) Viewed 1513 times
Oliver

Re: Template modification with polish charset - entities ?

Posted: Mon 16. Mar 2009, 16:39
by dellos
Yes by usign UTF8 you don't have that problem but the problem is on website by trying to feed som news from let's say phpBB2 you don't get the polish letters that's of phpBB2 working on iso-8859-2 not UTF8. Maby there is some sollution for backend in UTF8 and Website showing in iso-8859-2 ??