AyhanBaris.com Yazılım Mühendisi

utf8 general

=============================================================

Tablo :

DROP TABLE IF EXISTS `tt`;

CREATE TABLE IF NOT EXISTS `tt` (

`ad` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tt` (`ad`) VALUES

(’istanbul’),

(’ISTANBUL’),

(’İSTANBUL’),

(’ıstanbul’);

SELECT * FROM tt WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

SELECT * FROM tt WHERE ad LIKE ‘%ıstanbul%’;

Sonuc:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

utf8 turkish

=============================================================

Tablo :

DROP TABLE IF EXISTS `zz`;

CREATE TABLE IF NOT EXISTS `zz` (

`ad` varchar(255) COLLATE utf8_turkish_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

INSERT INTO `zz` (`ad`) VALUES

(’istanbul’),

(’İSTANBUL’),

(’ISTANBUL’),

(’ıstanbul’);

SELECT * FROM zz WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

İSTANBUL

SELECT * FROM zz WHERE ad LIKE ‘%ıstanbul%’;

Sonuç:

ıstanbul

ISTANBUL

* utf8 general’da ı,i u,ü o,ö gibi harfler aynı kabul edilirken , utf8 turkish’de aynı kabul edilmezler.

Thursday, September 29th, 2011 10:21 Kategori : Uncategorized. RSS 2.0 cevapla, trackback

utf8 general

=============================================================

Tablo :

DROP TABLE IF EXISTS `tt`;

CREATE TABLE IF NOT EXISTS `tt` (

`ad` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tt` (`ad`) VALUES

(’istanbul’),

(’ISTANBUL’),

(’İSTANBUL’),

(’ıstanbul’);

SELECT * FROM tt WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

SELECT * FROM tt WHERE ad LIKE ‘%ıstanbul%’;

Sonuc:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

utf8 turkish

=============================================================

Tablo :

DROP TABLE IF EXISTS `zz`;

CREATE TABLE IF NOT EXISTS `zz` (

`ad` varchar(255) COLLATE utf8_turkish_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

INSERT INTO `zz` (`ad`) VALUES

(’istanbul’),

(’İSTANBUL’),

(’ISTANBUL’),

(’ıstanbul’);

SELECT * FROM zz WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

İSTANBUL

SELECT * FROM zz WHERE ad LIKE ‘%ıstanbul%’;

Sonuç:

ıstanbul

ISTANBUL

* utf8 general’da ı,i u,ü o,ö gibi harfler aynı kabul edilirken , utf8 turkish’de aynı kabul edilmezler.

Thursday, September 29th, 2011 10:17 Kategori : Uncategorized. RSS 2.0 cevapla, trackback

utf8 general

=============================================================

Tablo :

DROP TABLE IF EXISTS `tt`;

CREATE TABLE IF NOT EXISTS `tt` (

`ad` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tt` (`ad`) VALUES

(’istanbul’),

(’ISTANBUL’),

(’İSTANBUL’),

(’ıstanbul’);

SELECT * FROM tt WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

SELECT * FROM tt WHERE ad LIKE ‘%ıstanbul%’;

Sonuc:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

utf8 turkish

=============================================================

Tablo :

DROP TABLE IF EXISTS `zz`;

CREATE TABLE IF NOT EXISTS `zz` (

`ad` varchar(255) COLLATE utf8_turkish_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

INSERT INTO `zz` (`ad`) VALUES

(’istanbul’),

(’İSTANBUL’),

(’ISTANBUL’),

(’ıstanbul’);

SELECT * FROM zz WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

İSTANBUL

SELECT * FROM zz WHERE ad LIKE ‘%ıstanbul%’;

Sonuç:

ıstanbul

ISTANBUL

* utf8 general’da ı,i u,ü o,ö gibi harfler aynı kabul edilirken , utf8 turkish’de aynı kabul edilmezler.

Thursday, September 29th, 2011 10:17 Kategori : Uncategorized. RSS 2.0 cevapla, trackback

utf8 general

=============================================================

Tablo :

DROP TABLE IF EXISTS `tt`;

CREATE TABLE IF NOT EXISTS `tt` (

`ad` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tt` (`ad`) VALUES

(’istanbul’),

(’ISTANBUL’),

(’İSTANBUL’),

(’ıstanbul’);

SELECT * FROM tt WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

SELECT * FROM tt WHERE ad LIKE ‘%ıstanbul%’;

Sonuc:

istanbul

ISTANBUL

İSTANBUL

ıstanbul

utf8 turkish

=============================================================

Tablo :

DROP TABLE IF EXISTS `zz`;

CREATE TABLE IF NOT EXISTS `zz` (

`ad` varchar(255) COLLATE utf8_turkish_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

INSERT INTO `zz` (`ad`) VALUES

(’istanbul’),

(’İSTANBUL’),

(’ISTANBUL’),

(’ıstanbul’);

SELECT * FROM zz WHERE ad LIKE ‘%İSTANBUL%’;

Sonuç:

istanbul

İSTANBUL

SELECT * FROM zz WHERE ad LIKE ‘%ıstanbul%’;

Sonuç:

ıstanbul

ISTANBUL

* utf8 general’da ı,i u,ü o,ö gibi harfler aynı kabul edilirken , utf8 turkish’de aynı kabul edilmezler.

Thursday, September 29th, 2011 10:15 Kategori : Uncategorized. RSS 2.0 cevapla, trackback