UseBB Community

The official board for UseBB help and discussion

UseBB Community » Help & Support » Turkish karakter problem (ö, ü, ç,..)

Turkish karakter problem (ö, ü, ç,..)

Moderators: Gaia.

Page: 1

Author Post
Member
Registered: Nov 2007
Posts: 28
Hello,
Windows konfiguration:
Apache 2.2.6, Phpmyadmin 2.11.3, Mysql 5.045, Php 5.25
Turkish karakter ex: "güvenlik" is normal, later linux sistem:
konfiguration: Apache 2.0.61, Mysql 5.0.51, Php 5.25, Phpmyadmin 2.11.3
Linux sistem:
güvenlik >güvenlik
çalisir > Çalısır
öncelikle > öncelikle,...

Windows sistem:
Work normaly; güvenlik > güvenlik,...


(sorry my english)
« Last edit by nxturk on Mon Dec 31, 2007 2:12 pm. »
Developer
Registered: Apr 2004
Posts: 2180
Location: Belgium
Are you using the same collation for the MySQL tables as you did on the previous server?

This can be a tricky matter... PHP by default (and UseBB) only supports single byte character sets, so using UTF-8 (Unicode) would be a bad idea (Unicode tends to be the default collation on some Linux distributions).
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
Member
Registered: Nov 2007
Posts: 28
Je vais m'exprimé en francais, je connais pas l'anglais,
J'utilisais sur windows xp profesyonel la konfiguration:
Apache 2.2.6, Phpmyadmin 2.11.3, Mysql 5.045, Php 5.25
Quand j'ai créé la base de donnés j'ai utilisé le default: 'utf8_unicode_ci'
J'utilisais php 5.2.5, apache 2.2.6, mysql 5.0.45 et phpmyadmin 2.11.3.

Dans linux j'utilise: Apache 2.0.61, Mysql 5.0.51, Php 5.25, Phpmyadmin 2.11.3
J'utilise 'utf8_unicode_ci' aussi sur linux

Et aujordh'ui j'ai installer windows server 2008 sur mon autre disque dur et j'ai testé sa a bien fonctionné pas de probléme.

Est-ce que a cause de la diférence de version apache ou mysql sous windows et linux ?
« Last edit by nxturk on Tue Jan 01, 2008 6:33 pm. »
Moderator
Registered: Oct 2005
Posts: 425
Location: canada
There are no differences between versions of apache/mysql on either a linux or windows box. It just all depends on the actual version installed. Perhaps try upgrading your apache/mysql versions to see if that works.
Member
Registered: Nov 2007
Posts: 28
I will try, I am new linux user
Member
Registered: Nov 2007
Posts: 28
J'ai trouvé, mon linux est en turk alors firefox est configuré en turk et dans le menu 'Affichage > Encodage Des Caractère' Il est sur 'iso 8859-9' quand je le mais sur UTF8 les caractère redevienne normale.

Mais j'ai une petite question encore;
Les caractère change parceque je suis en localhost ou quelque chose paraport du script-sql ?

Je pense parceque je suis en localhost, mais je voudrai étre certain, et merci de votre aide toulemond, thanks all.
Member
Registered: Nov 2007
Posts: 28
Enfait y a pas un moyen en editant le script que les caractére soit en unicode(utf8) automatiquement ?
J'ai essayer:
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
Developer
Registered: Apr 2004
Posts: 2180
Location: Belgium
Please, only use English on this forum. Thank you.
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
Member
Registered: Nov 2007
Posts: 28
English:
I found my linux is turk then firefox is configured turk and in the menu 'View> Encoding Des Caractčre' It was on 'iso 8859-9' when I UTF8 but on the character return to normal.

But I have a small question yet;
The character change because I am localhost or something paraport-SQL script?

I think because I am localhost, but I want to be sure, and thanks for your help toulemond, thanks all.

--------------

Infact there is not a means by by editing the script that the character is Unicode (UTF-8 ) Automatically?
I test:
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

No changed

Sorry i no english utilise google translate..
« Last edit by nxturk on Wed Jan 02, 2008 10:23 pm. »
Developer
Registered: Apr 2004
Posts: 2180
Location: Belgium
The character encoding is set in the language file. When you use the English translation ISO-8859-1 is used, which should be fine for most West-European languages. When posting foreign characters this results in HTML entities being sent.

You could change the encoding in the translation's PHP file. Make sure you are using a single byte encoding (thus, no UTF-8 since PHP by default does not support it and UseBB does so neither). Multibyte will only be supported as of UseBB 2.
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog

Page: 1

UseBB Community » Help & Support » Turkish karakter problem (ö, ü, ç,..)

UseBB Community is powered by UseBB 1 Forum Software