Turkish Charset in DB and table

[Huseyin Yeni]

Hi All,

I have created a db called "db3d" and created a table as follows:


CREATE DATABASE `db3d` /*!40100 DEFAULT CHARACTER SET latin5 */;


CREATE TABLE `gundem_table` (
`gundemno` int(10) unsigned NOT NULL auto_increment,
`sayino` int(10) unsigned NOT NULL default '0',
`oncelik` int(10) unsigned NOT NULL default '0',
`baslik` varchar(60) default NULL,
`ajansveyayazar` varchar(60) character set latin5 collate latin5_bin NOT NULL default '',
`tarih` datetime NOT NULL default '0000-00-00 00:00:00',
`aciklama` text NOT NULL,
`url` varchar(250) NOT NULL default '',
PRIMARY KEY (`gundemno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5 COMMENT='Gundemden sectiklerimiz icin kullanilmaktadir';

As you see the DB and table in Turkish Characterset but I can not insert TURKISH characters...

You see the results from query by PHP

Sayı No:100 Gündem No:1 Oncelik:1 Tarih:2005-07-18 16:55:00
ü??ç??IklöçÖÇ?Ü? / ü??ç??IklöçÖÇ?Ü?
ü??ç??IklöçÖÇ?Ü?
ü??ç??IklöçÖÇ?Ü?