Advanced search  

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

Pages: [1]   Go Down

Author Topic: Database problem on Turkish language  (Read 12850 times)

0 Members and 1 Guest are viewing this topic.

slicer1

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Database problem on Turkish language
« on: November 07, 2006, 07:53:36 pm »

Hi
I was working fine.
But I moved to another host then I upload database. On phpmyadmin there is no problem. I'm using latin5_turkisch_ci
Because I need those characters ş ğ ü ç ö İ ı...
When I open my site there is different character like ? 破 .
How can I fix it?
is there a file like on phpbb2 db.php
Because on phpbb2 if you add these to db.php it is fixed.

mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
Logged

Nibbler

  • Guest
Re: Database problem on Turkish language
« Reply #1 on: November 07, 2006, 07:58:35 pm »

Coppermine supports only UTF-8 (unicode). You should convert your database content to UTF-8. See charsetmgr.php.
Logged

slicer1

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Database problem on Turkish language
« Reply #2 on: November 07, 2006, 09:29:51 pm »

how can I convert it to utf-8
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database problem on Turkish language
« Reply #3 on: November 08, 2006, 08:53:10 am »

Logged

izfd_adm

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Database problem on Turkish language
« Reply #4 on: July 22, 2008, 01:48:54 pm »

Hi,

I've changed collation and character set from mysql.ini file as utf8
I've changed collation and character set of database to utf8_turkish_ci and utf_8,
I've changed collation and character set of all tables to utf8_turkish_ci and utf_8,
I've changed language and character set option from administrative settings page to Unicode (utf-8)
browser language settings is also selected as utf8...

But i am still having problems at turkish characters  like ç , ğ , ş while browsing pages.
This problem occurs at data which retrieved from mysql 4.1. (like categories , album names etc)

Thanks in advance...

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database problem on Turkish language
« Reply #5 on: July 22, 2008, 03:00:04 pm »

Post a link to your gallery for a start  ::)
Logged

serkanarslan72

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Database problem on Turkish language
« Reply #6 on: September 03, 2008, 10:55:31 am »

Arkadaşlar ben türkçeden başka dil bilmiyorum. Foto galeriyi kurmak istiyorum fakat bir türlü kuramadım. Türkçe olarak kurulumu detaylı anlatabilecek bir arkadaş yokmu. Türkiyede hiçbir forumda bulamadım kurulumu resimli anlatan.

Dosyayı nereden indireceğiz. Chmod ayarları hangi dosyalara yapılacak. Detaylı anlatırsanız sevinirim.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database problem on Turkish language
« Reply #7 on: September 03, 2008, 04:33:29 pm »

You're not allowed to post Turkish here, as no supporter is speaking Turkish. Hijacking this thread with your irrelevant reply is just silly. Locking.
Logged
Pages: [1]   Go Up
 

Page created in 0.037 seconds with 20 queries.