Welcome to Geeklog, Anonymous Sunday, December 04 2022 @ 09:29 am EST

Geeklog Forums

lost slovenian characters after migrating to new webhost


Status: offline

gape

Forum User
Full Member
Registered: 05/30/02
Posts: 138
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)) ...
 Quote

Status: offline

gape

Forum User
Full Member
Registered: 05/30/02
Posts: 138
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?)
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
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. Exclamation Exclamation Exclamation
 Quote

Status: offline

gape

Forum User
Full Member
Registered: 05/30/02
Posts: 138
Quote by: 1000ideen

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. Exclamation Exclamation Exclamation


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?
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
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?
 Quote

Status: offline

gape

Forum User
Full Member
Registered: 05/30/02
Posts: 138
Quote by: 1000ideen

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
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
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';
 Quote

Status: offline

gape

Forum User
Full Member
Registered: 05/30/02
Posts: 138
Quote by: 1000ideen

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

Razz

ps
ty 4 ur time
 Quote

Status: offline

gape

Forum User
Full Member
Registered: 05/30/02
Posts: 138
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
Razz
 Quote

All times are EST. The time is now 09:29 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content