Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 08:10 am EDT

Geeklog Forums

Character Issues


Status: offline

Dazzy

Forum User
Full Member
Registered: 07/19/03
Posts: 200
Location:N. Ireland
Hey all

Following an update to 1.4.1rc1 I have issues displaying characters on my site for example the £ (pound sign) just shows as a ? mark.

Any ideas?


Many Thanks
Dazzy
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you change character sets? Or were you already using UTF-8 before the upgrade?

bye, Dirk
 Quote

Status: offline

Dazzy

Forum User
Full Member
Registered: 07/19/03
Posts: 200
Location:N. Ireland
I was using whatever the default was in 1.4.0sr5.1, think it was non utf-8, I need utf8 now for the multi lingual aspect.
Dazzy
 Quote

Status: offline

Dazzy

Forum User
Full Member
Registered: 07/19/03
Posts: 200
Location:N. Ireland
Characters show correctly in preview mode only mess up when you submit.
Dazzy
 Quote

Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
I wonder if it is the Collation setting. Geeklog does not change the MySQL table collation to utf-8 upon installation even if you choose utf-8 as the default character set.

Dirk, I have two questions:

Is there an easy way to change the existing collation from Latin1 to utf-8?

Is it possible to set the collation to utf-8 by default upon installation?

Merry Christmas!

Sam
 Quote

All times are EDT. The time is now 08:10 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