The secure CMS.

Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 06:09 pm EST

Geeklog Forums

Character Issues

 New Topic  Post Reply
 12/22/06 05:36pm (Read 2,134 times)  
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
 12/22/06 05:57pm  
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
 12/23/06 03:49am  
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
 12/25/06 08:17am  
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
 12/25/06 04:58pm  
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
 New Topic  Post Reply
All times are EST. The time is now 06:09 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