UseBB Community

i can write those letters but they show up in the posting as questionsmarks, all three of them .

my OS, apache, mysql (database and tables), php can write them.
any clues? i see that this board can write and view them

Server version: Apache/2.0.58
mysql Ver 14.7 Distrib 4.1.20, for portbld-freebsd6.0 (i386) using 5.0
FreeBSD 6.0-RELEASE FreeBSD 6.0-RELEASE
PHP 4.4.2 (cli)

You are probably using a database collation other than latin1. This is a new system since MySQL 4.1. So, you should set the collation to latin1 (for ISO-8859-1) or whichever encoding you use.

Unfortunately, I guess there isn't an easy way to convert an entire database, tables and fields at once. A quick fix is to use $conf['force_latin1_db'] or to run a SET NAMES query on every connection.

Hi

i have done this in mysql

alter database FOO default character set latin1 collate latin1_swedish_ci
and then set alt the tables like this
alter table usebb_badwords default character set latin1 collate latin1_swedish_ci

and atlast i did this, taking our advice
$conf['force_latin1_db'] = 1;

still i cant use the letters æøå

do i have to reload any files to activate the changes?

You need to alter all the fields too, not just the tables.

Note that config option only works when using mysqli, btw.

altering the fields should convert the excisting fields.
i still cant enter new posts with æøå

any suggestions? if you are very sure that it is a problem with mysql then i will have to ask that question there (in their forums)

if i do like this

vi test.sql

CREATE TABLE testtable (TEST varchar(64));
INSERT INTO testtable VALUES ("æøå");
SELECT * FROM testtable;

:wq


and then
mysql -p foo < test.sql

then it shows the result
TEST
æøå


and that proves that my OS, mysql, php etc is working fine
the forum prolly works as a client? which charset does that use?
is there some spescial modds for FreeBSD?

There isn't any character converting done on the input. UseBB's character set is ISO-8859-1 by default (English language set). So, the browsers sends it this way and it gets saved with this character set.

Over here we also use the latin1_swedish_ci MySQL collation. I suppose the way you created that table is with an unicode charset while UseBB uses ISO-8859.

If this doesn't solve the problem, I'm sorry if I can't help. I suggest asking help on the MySQL forums.

how do i uninstall UseeBB?
i wanna try installing it from scratch again and see if there is anything i can do different to solve my problem

Remove all the files and clear the database. You could also check the collation of the database afterwards, before installing the forum again. Ofcourse, this only works as long as PHP or the MySQL extension doesn't reset the collation.