Serbian latin characters Serbian latin characters
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Serbian latin characters

Started by bokonon, November 02, 2007, 02:13:53 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

bokonon


  Hi there!

  I have a problem with characters in coppermine - if I set the charset to utf-8, some Serbian latin characters wont display properly. I am talking about the characters in category titles, album titles or image description.

  I have tried other charsets offered in the config panel, but none of them does the job. The most I can get it to do is show two Serbian latin characters - š and ž.

  Any ideas? Thanx :)

  LP

   

bokonon


   Maybe I should add that I'm using MySQL, and here are the charset parameters:

   MySQL charset: UTF-8 Unicode (utf-8)
   MySQL connection collation: utf8_unicode_ci

   

Joachim Müller

Did you use another charset before you switched to utf-8? If yes, you'll have to convert the textual content of your database to utf-8
Post a link to your gallery for a start.

bokonon

QuoteDid you use another charset before you switched to utf-8?

   No, I have just installed coppermine for the first time ever.

Quoteyou'll have to convert the textual content of your database to utf-8

   There is no previous textual content. Whatever I type in coppermine automatically gets displayed as question marks or something similar.




Joachim Müller

Post a link to your gallery for a start.

bokonon


   Here it is: http://www.serbiatravelers.org/foto/

   Please check out the first category... the question marks in the category descriptions are also supposed to be letters (I typed them as letters, but after saving they somehow turned into question marks). The charset is set to unicode - utf8.


Joachim Müller

Please post here the string that is suppossed to show - I'm trying to replicate on my testbed wether this is a bug.

bokonon


   Ok, here is what I actually typed: a b c d   ....   š č ć ž đ 
   and here is what it shows after having been saved: a b c d .... š ? ? ž ?


bokonon


   I've done some research and guess what I've found out :)

   When I check my SQL table, I see that table "categories" (as well as all the other table) has the following charset:

   Collation     latin1_swedish_ci

   While in "config" panel of my coppermine gallery, it says "utf-8".

   How can I get all my gallery tables to be utf-8 instead of latin1_swedish?

bokonon


   I have managed to fix the problem by editing the SQL file and reinstalling the database. I added "COLLATE 'utf8_general_ci'" at the end of every "CREATE TABLE" statemend.

   It all worked fine untill I enabled the bridge with the simple machines forum - when the charset got messed up again (although the database still said utf8_general_ci). However, when I disabled the bridging, the problem disappeared.

   Any idea why this happens? It would be great if I could use the bridge and have my characters displayed properly at the same time :)