1 Topic by jerry2

(0 replies, posted in PunBB 1.2 troubleshooting)

Hi there

I want to translate phpbb forum I have to punbb. Everything works, but our special codes are lost using mysql 5 :-( The letters ??žš???ŽŠ? are changed for ???? or empty boxes. This is a know problem for me and I usually get past it using the SQL statements:

SET CHARACTER SET latin2
SET NAMES latin2

But this converter is so complex, I am not sure where to put this two requests :-( They should be before anything is read from database and before anything is wriiten to database.

an the author of this great tool or somebody else plese help me?

I put this:

                $query = 'SET CHARACTER SET latin2';
                $db->query($query);
                $query = 'SET NAMES latin2';
                $db->query($query);

info function insertdata before the INSERT is made, but doesn't seem to help :-(

Yours

Jerry

Go to forum: PunBB 1.2 troubleshooting

2 Reply by jerry2

(4 replies, posted in PunBB 1.2 discussion)

Hi

Just a question on mysql fulltext search. Isn't it impracticall? It can use only one table to index the words, so how can I use it on my own code that had members in one table and posts in another and the keyword search would look in the member name or a word in the post? Is the way to do it using separate 2 indexes and then joining them together somehow?

Jerry

Go to forum: PunBB 1.2 discussion