Geeklog Forums

my problem is that geeklog site was moved to another server
database was exported thru phpmyadmin
but
when it was imported at another host - it displays slovenian characters in some other format ... or something
the version of geeklog is 1.4.1
i tried like a milion varieties (other charsets at export/import), but none worked
i even changed default encoding to utf-8 in config.php and in header.php
on older server the website was running on charset windows-1250 (defined in header.php and in language files)
after i changed all i know to utf-8 (couse on my computer i CAN see proper characters - utf-8 encoded if i check the export file) i noticed that browser displays the texts that are read from language files properly
but those from database do not

so ... what am i missing?
how should i resolve this issue?

the only thing (that i can't use) ... that i got from provider is:
*********************************
> Apache ... locale ... LC_CTYPE=sl_SI.ISO8859-2.
>
> tried 'latin2' charset?
SET NAMES 'latin2'
**********************************

as i understood i should use latin2
but i could not make it work (a milion varieties (other charsets at export/import)) ...

maybe it helps:
i noticed this error
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
when browsing values in tables - with phpmyadmin
im not 100% sure, but afaik older server was runinng 4.x mysql
the new server is running 5.x

was reading that downgrading sql fixes the error
something about ending the line, or something ...

(btw - i cant edit my own post?)

Maybe the error is here:

// Use of 'utf-8' is recommended for multi-language sites
$_CONF['default_charset'] = 'latin1';

I was told that the latest MySQL supports this 'default_charset' whereas the old one just ignored it.

im trying to get it work on utf
so im using
$_CONF['default_charset'] = 'utf-8';
atm

is there any special setting to make geeklog use utf-8 files?

What did you have in these positions on the old server with MySQL 4?

$_CONF['language'] =
$_CONF['locale'] =

// Use of 'utf-8' is recommended for multi-language sites
$_CONF['default_charset'] =

Did the hoster say the old system was 'latin2' as default?

old system was displaying texts in windows-1250 format (latin2 afaik) - couldnt make that to work - so i tried utf
now im looking for ideas ... how to procede

i use this in both cases
$_CONF['language'] = 'slovenian';
$_CONF['locale'] = 'sl_SI';

usually after few combinations it works - this one does not ... cant figure out why ...
and there are so many encodings on so many places

Do you have access to the old system? Can you convert it into utf-8 there and see if it works? Afterwards go to the new system? There are so many variables in it.

I have this now and it works:

$_CONF['language'] = 'german_formal_utf-8';
$_CONF['locale'] = 'de_DE.UTF-8';

// Use of 'utf-8' is recommended for multi-language sites
$_CONF['default_charset'] = 'latin1';

will try it your way


... i have access, but domain points to new server ...
obviously i dont know enough about those encodings to make it work

somehow ... i need to know
if i exported the database in utf encoding
and i imported it as such into new database
how do i setup geeklog to show proper characters - knowing the fact that exported file shows proper characters on my computer



ps
ty 4 ur time

i tried,
now im using
$_CONF['language'] = 'slovenian_utf-8';
$_CONF['locale'] = 'sl_SI.UTF-8';
$_CONF['default_charset'] = 'utf-8';

and in header.thtml i have
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

when i display page - it has errors again - wrong chars or even questionmarks
and browser automatically selects windows-1250 encoding - and texts from language files are displayed correctly
those from database have errors
if i select the encoding manually in browser and choose utf-8 the texts from language files have errors, but the ones from database display much nicer, but still not as they should - afaik - it is displaying latin1 charset, but we - slovenians - use latin2

... i hope i make any sense