Zobacz temat - [Other] UFT-8 encoding

To jest tylko wersja do druku, aby zobaczyć pełną wersję tematu, kliknij TUTAJ
	phpBB2 by Przemo Support forów phpBB2 modified by Przemo

English version - [Other] UFT-8 encoding

evilmc - 02-10-2008, 21:09
Temat postu: [Other] UFT-8 encoding

I changed encoding for the entire base of the Forum utf8_unicode_ci and also lang_main.php I put $ lang [ 'encoding'] = 'utf-8', but now I have a problem with the letters š-Š , ž-Ž...and instead of the characters put questions.

www.serbianunderground.com/forum/

Is someone knows how to resolve this problem?

[ Added: 02-10-2008, 23:57 ]
I am sorry to writing again,

Is someone knows how to resolve this problem?

tosiek - 03-10-2008, 14:08

evilmc napisał/a:

lang_main.php

If you want to use utf8 all you need to convert files to utf8 for example, by using a program
http://www.gzegzolka.com/?m=down ( convert all lang files )

evilmc napisał/a:

$ lang [ 'encoding'] = 'utf-8'

Change:

Kod:

setlocale(LC_ALL, 'pl_PL.utf-8');
$lang['ENCODING'] = 'utf-8';

pl_PL << change to your language

evilmc - 03-10-2009, 19:38

Now, I have a problem with the letters Š-š, all other works.
pls help

Original letters:

Cytat:

Ako imate problema sa aktivacijom vašeg naloga prilikom registracije, molimo vas da nam pišete na email: evil@serbianunderground.com i sredićemo Vaš problem.[/b]

Bad letters:

Cytat:

Ako imate problema sa aktivacijom va�Aeg naloga prilikom registracije, molimo vas da nam pi�Aete na email: evil@serbianunderground.com i sredićemo Va�A problem.

tosiek - 03-10-2009, 21:22

evilmc napisał/a:

Š-š

Only with this letters?

copy bad and paste:

Cytat:

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text,'bad','original');

example:

Cytat:

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text,'�A','š');

Before make backup of a database!

evilmc - 04-10-2009, 00:59

tosiek napisał/a:

Only with this letters?

yes.

tosiek napisał/a:

copy bad and paste:
Quote:
UPDATE phpbb_posts_text SET post_text = REPLACE('post_text','bad','original');

example:
Quote:
UPDATE phpbb_posts_text SET post_text = REPLACE('post_text','�A','š');

Before make backup of a database!

Not working

tosiek - 04-10-2009, 09:54

Ooo, sorry. fixed:

Cytat:

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text,'old','new');

evilmc - 04-10-2009, 13:36

tosiek, post text it's okey, but topic and main forum have problems.

check this topic:
www.serbianunderground.com/forum/-vt8078.htm

šššššš not working, ŠŠŠŠŠŠŠŠ working :S

tosiek - 04-10-2009, 14:23

evilmc, you must change all text or char columns

Cytat:

UPDATE phpbb_posts_text SET post_subject = REPLACE(post_subject,'old','new');

Cytat:

UPDATE phpbb_topics SET topic_title = REPLACE(topic_title,'old','new');

Cytat:

UPDATE phpbb_topics SET topic_title_e = REPLACE(topic_title_e,'old','new');

siper - 04-10-2009, 15:47
Temat postu: Re: UFT-8 encoding

evilmc napisał/a:

'

Forum not working...

evilmc - 04-10-2009, 19:09
Temat postu: Re: UFT-8 encoding

siper napisał/a:

evilmc napisał/a:

'

Forum not working...

Forum now working.

[ Added: 05-10-2009, 02:08 ]

tosiek napisał/a:

evilmc, you must change all text or char columns

Cytat:

UPDATE phpbb_posts_text SET post_subject = REPLACE(post_subject,'old','new');

Cytat:

UPDATE phpbb_topics SET topic_title = REPLACE(topic_title,'old','new');

Cytat:

UPDATE phpbb_topics SET topic_title_e = REPLACE(topic_title_e,'old','new');

i update this sql, but not working