Welcome to Geeklog, Anonymous Tuesday, December 10 2024 @ 07:02 pm EST
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- 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
9
13
Quote
All times are EST. The time is now 07:02 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