Welcome to Geeklog, Anonymous Wednesday, April 30 2025 @ 03:59 pm EDT
Geeklog Forums
utf-8, geeklog 1.4.1b1 and MySQL?
Status: offline
artur
Forum User
Junior
Registered: 08/18/06
Posts: 16
Hello,
I have problems with utf-8 language files / database entries.
My site is not in english.
geeklog is configured to use utf-8 language files
($_CONF... language, /locale / default_charset).
database entries are in utf-8.
problem:
topic names are shown correctly and stories not. (problems with not english caracters)
if for quick solution i add to function DB_query (in file lib-database.php)
mysql_query ('set names utf8');
then stories are OK and topics names are not OK.
if I convert database entries (already in utf-
again to utf-8, then this solves most problems, but some characters (cap U umlaut) is not shown correctly.
in phpMyAdmin 2.8.2.4, on page "variables" some values for charset are utf8, some latin1. Is this OK?
How to solve this problem?
Artur
I have problems with utf-8 language files / database entries.
My site is not in english.
geeklog is configured to use utf-8 language files
($_CONF... language, /locale / default_charset).
database entries are in utf-8.
problem:
topic names are shown correctly and stories not. (problems with not english caracters)
if for quick solution i add to function DB_query (in file lib-database.php)
mysql_query ('set names utf8');
then stories are OK and topics names are not OK.
if I convert database entries (already in utf-

in phpMyAdmin 2.8.2.4, on page "variables" some values for charset are utf8, some latin1. Is this OK?
How to solve this problem?
Artur
12
15
Quote
All times are EDT. The time is now 03:59 pm.
- 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