Page 1 of 1

multi language forum

Posted: Sat Jul 16, 2016 12:21 pm
by Flegy33
Hello,

last few days trying to get topics and posts to show other languages as example Croatian čćžđš or arabic "تقديم تقرير عن اي خطا داخل اللعبه" but only what see after post is ??????? , so what I done so far is change text type of column into ntext but I think need also add N at inserting query but not sure what need to edit in php file.

p.s: when is inside DB other language it show fine on forum just problem is inserting on new topic / reply

thanks in advance

Re: multi language forum

Posted: Mon Jul 18, 2016 1:36 pm
by Flegy33
any help is welcome.

Re: multi language forum

Posted: Tue Jul 19, 2016 8:12 am
by AmigoJack
Nobody knows which DBMS you're using. MySQL supports out of the box UTF-8, and phpBB does the same (as you can see with your own post: characters are perfectly stored). Changing the database table column type is the wrong approach.

But since your registration process doesn't allow non-ASCII characters for a username I don't understand why you are wanting them anywhere else then:
20160719 js crap.png
As per http://www.maxko-forum.info/viewtopic.p ... 26#p217326 phpBB is not the problem, since the preview still displays characters as expected. You need to tell us your DBMS (and which content the variable $dbms has in your /config.php).

Re: multi language forum

Posted: Tue Jul 19, 2016 2:33 pm
by Flegy33
thanks for try help. Yes we dosent allow ASCII characters on names because forum and our game use same accounts, but with ASCII characters thay can cheat inside game. We want only on topics and posts to work ASCII as you see when you make topic it show only ????? but when insert manual ASCII character in database it load fine and show in topic fine.

Forum is hosted on CentOS 6.7 , using ODBC conect windows 2012 r2 server where is MMSQL database.

Have any suggestion where can be problem?

Re: multi language forum

Posted: Thu Jul 21, 2016 7:43 am
by AmigoJack
Flegy33 wrote:ODBC [...] MMSQL
So that means that
AmigoJack wrote:(and which content the variable $dbms has in your /config.php)
should be:

Code: Select all

$dbms = 'mssql_odbc';
right?

I have no experience with MSSQL thru ODBC and I'm also unable to test it. As per i.e. http://stackoverflow.com/questions/1322421/ you need to jump thru a couple of hoops to your Unicode thru ODBC, so using MSSQL directly rather than thru ODBC sounds more promising (as /includes/db/mssql.php already does this:

Code: Select all

@ini_set('mssql.charset', 'UTF-8');

Re: multi language forum

Posted: Fri Jul 22, 2016 3:57 pm
by Flegy33
tryed both but its same

#$dbms = 'mssql_odbc';
$dbms = 'mssql';

when you tryed it was direct mssql.

Re: multi language forum

Posted: Fri Jul 22, 2016 4:00 pm
by JimA
Be aware that config.php data is cached in phpBB. So in order for those changes to take effect, you would need to delete all files from the cache directory on your server except for .htaccess and index.htm. :)

Re: multi language forum

Posted: Fri Jul 22, 2016 9:31 pm
by Flegy33
Yes I cleared catche on try, also played with ODBC driver but nothing didnt helped. Maybe need add N beffore inserting new topic/post?

Re: multi language forum

Posted: Sat Jul 23, 2016 8:12 pm
by Flegy33
any more idea what I can try to solved problem?

Re: multi language forum

Posted: Wed Jul 27, 2016 7:02 pm
by Flegy33
bump