Turkish Charset in DB and table
Posted by: Huseyin Yeni
Date: July 18, 2005 07:47AM

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öçÖÇ?Ü?

Options: ReplyQuote


Subject
Views
Written By
Posted
Turkish Charset in DB and table
3442
July 18, 2005 07:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.