Hello

I have migrated joomla site from windows 2003 server to fedora 9. During the migration went into database encoding problems but i fixed converting from latin1 to utf8 collation.(macedonian keyboard). Now the problem is with the links linked to files.

when i click on some link to a file i get:

Not Found

The requested URL /ISO_doc/QMS/ПРОЦЕДУРИ З� КВ�ЛИТЕТ/Процедури за Управување �о документите за квалитет - верзија 02.doc was not found on this server.

This is a example link from "Page Source" <a href="/ISO_doc/QMS/%D0%9F%D0%A0%D0%9E%D0%A6%D0%95%D0%94%D0%A3%D0%A0%D 0%98%20%D0%97%D0%90%20%D0%9A%D0%92%D0%90%D0%9B%D0% 98%D0%A2%D0%95%D0%A2/%D0%9F%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D 0%B8%20%D0%B7%D0%B0%20%D0%A3%D0%BF%D1%80%D0%B0%D0% B2%D1%83%D0%B2%D0%B0%D1%9A%D0%B5%20%D1%81%D0%BE%20 %D0%B4%D0%BE%D0%BA%D1%83%D0%BC%D0%B5%D0%BD%D1%82%D 0%B8%D1%82%D0%B5%20%D0%B7%D0%B0%20%D0%BA%D0%B2%D0% B0%D0%BB%D0%B8%D1%82%D0%B5%D1%82%20-%20%D0%B2%D0%B5%D1%80%D0%B7%D0%B8%D1%98%D0%B0%2002 .doc


Anyone have an idea what can be the problem?

Hi,

How did you convert your database from latin1 to utf8?
You should use iconv to convert the sql dump to utf8. Take a look at this whole thread for details

Regards

thanks for the reply bathory

i have used this script and conversion went fine:

DBFROM=dp
DBTO=dp
LOGIN=dp
PASS=XXX

mysqldump --extended-insert=FALSE --default-character-set=latin1 -u

$LOGIN -p$PASS $DBFROM >dp.sql

cat dp.sql |sed -e 's/DEFAULT CHARSET=latin1;/DEFAULT CHARSET=utf8 COLLATE utf8_bin;/'>dp2.sql

cat dp2.sql |sed -e 's/SET NAMES latin1/SET NAMES utf8/'>dp3.sql

echo " drop database $DBTO; create database $DBTO character set utf8 collate utf8_bin;"|mysql -u $LOGIN -p$PASS

mysql -u $LOGIN -p$PASS $DBTO <dp3.sql


Fixed the problem with installing new version of fedora 12.
I think the problem was something to do with internationalization (i18n)
or with locale.