Tüm Araçlar
  • Tema Seçeneği
  • Site Sesleri
  • Bildirimler
  • Özel Mesaj Al
lostyazilim
tr.link

İmpex Türkçe Karakter Sorunu

 8 Mesajlar 2.389 Okunma
lstbozum
tr.link

#1
myenes myenes $php = new PHP(); Kullanıcı
  • Üyelik 28.09.2011
  • Yaş/Cinsiyet 38 / E
  • Meslek Back-end Developer
  • Konum İstanbul Avrupa
  • Ad Soyad E** G**
  • Mesajlar 1051
  • Beğeniler 253 / 258
  • Ticaret 5, (%100)
Mehaba arkadaşlar öncelikle durumu size bir özet geçeyim :) mybb 1.6 sürümünü kullanmaktayım vbulletin 3.8.4 sürümüne geçiş yapacağım. Bunun için impex kullanarak dönüşüm işlemini yaptım ancak konular ve üyelerin aktarım sırasında gördüm ki "ışğ" harfleri "?" olarak gözükmekte "üö"harflerinde sorun yok ancak bu 3 harfte "?" gösteriyor ne yapmam lazım ?
 

 

wmaraci
reklam

#2
derinport derinport derinport.in Kullanıcı
  • Üyelik 17.02.2012
  • Yaş/Cinsiyet - / E
  • Meslek webmaster
  • Konum
  • Ad Soyad ** **
  • Mesajlar 2
  • Beğeniler 0 / 0
  • Ticaret 1, (%100)
mybb de kullanmış olduüunuz db karekter seti yeni kurmuş olduğunuz vb deki karekter seti ile uyumlu olmayabilir
bu tür durumlar için impexde karekter seti girilen bölüm olmalı
// Advanced Target yeni vb db karekter set
// Advanced Source eski mybb karekter set

ImpExConfig.php
içerisinden ayarlayabilirsin
 

 

#3
myenes myenes $php = new PHP(); Kullanıcı
  • Üyelik 28.09.2011
  • Yaş/Cinsiyet 38 / E
  • Meslek Back-end Developer
  • Konum İstanbul Avrupa
  • Ad Soyad E** G**
  • Mesajlar 1051
  • Beğeniler 253 / 258
  • Ticaret 5, (%100)
Dediğini denedim yine aynı sorunu verdi. maalesef :(
 

 

#4
myenes myenes $php = new PHP(); Kullanıcı
  • Üyelik 28.09.2011
  • Yaş/Cinsiyet 38 / E
  • Meslek Back-end Developer
  • Konum İstanbul Avrupa
  • Ad Soyad E** G**
  • Mesajlar 1051
  • Beğeniler 253 / 258
  • Ticaret 5, (%100)
bu sorunu nasıl çözebilirim bilgisi olan var mı ?
 

 

wmaraci
wmaraci

#5
Bugras Bugras WM Aracı Kullanıcı
  • Üyelik 11.06.2011
  • Yaş/Cinsiyet 28 / E
  • Meslek M.I.S
  • Konum
  • Ad Soyad B** S**
  • Mesajlar 771
  • Beğeniler 75 / 73
  • Ticaret 0, (%0)
Bu sorun tam bir baş belası düzelmiyor bendede aynı sorun var bilen varmı paylasşın lütfen
 

 

#6
nanoeray nanoeray WM Aracı Kullanıcı
  • Üyelik 22.10.2012
  • Yaş/Cinsiyet 30 / E
  • Meslek Back-End Developer
  • Konum İzmir
  • Ad Soyad E** G**
  • Mesajlar 16
  • Beğeniler 7 / 1
  • Ticaret 1, (%100)
bende öyle yapınca ? leri gidiyor ancak değişik şeyler geliyor tr karakterler yerine .s

(Çoh büyük hortlatma yaptım galiba :D)
myenes

kişi bu mesajı beğendi.

#7
myenes myenes $php = new PHP(); Kullanıcı
  • Üyelik 28.09.2011
  • Yaş/Cinsiyet 38 / E
  • Meslek Back-end Developer
  • Konum İstanbul Avrupa
  • Ad Soyad E** G**
  • Mesajlar 1051
  • Beğeniler 253 / 258
  • Ticaret 5, (%100)

nanoeray adlı üyeden alıntı

bende öyle yapınca ? leri gidiyor ancak değişik şeyler geliyor tr karakterler yerine .s

(Çoh büyük hortlatma yaptım galiba :D)


Uyuyan devi uyandırdın :)

Sorunu:

ALTER TABLE `access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminhelp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `administrator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminutil` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `album` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `albumpicture` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `albumupdate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcement` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcementread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachment` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmentpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmenttype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmentviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `avatar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `bbcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `bookmarksite` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarcustomfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarmoderator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cpsession` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cron` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cronlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customavatar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customprofilepic` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `datastore` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `deletionlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `discussion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `discussionread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `editlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `event` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `externalcache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `faq` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forum` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumprefixset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `holiday` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `humanverify` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvanswer` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvquestion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `icon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `imagecategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `imagecategorypermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infraction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionban` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractiongroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionlevel` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `language` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `linkback` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `mailqueue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderatorlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `notice` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `noticecriteria` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `noticedismissed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `passwordhistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentapi` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentinfo` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymenttransaction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrase` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrasetype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `picture` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `plugin` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pm` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmreceipt` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmtext` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmthrottle` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcast` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcastitem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `poll` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pollvote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `post` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postedithistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `posthash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postindex` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postparsed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefix` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `product` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `productcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `productdependency` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profileblockprivacy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefieldcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilevisitor` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `ranks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reminder` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reputation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reputationlevel` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rssfeed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rsslog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `search` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `session` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `setting` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `settinggroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigparsed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigpic` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smilie` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupicon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupmember` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgrouppicture` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `spamlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `stats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `strikes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `style` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribediscussion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeevent` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeforum` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribegroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribethread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscription` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscriptionlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscriptionpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumcounter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumpost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadcounter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadpost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tagsearch` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tagthread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `template` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `templatehistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `thread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadrate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadredirect` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `thread_serviceupdate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `upgradelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `useractivation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `useractivation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userban` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userchangelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercss` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercsscache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergroupleader` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergrouprequest` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userlist` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usernote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userpromotion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertextfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertitle` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_blacklist` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_likes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_linkback` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_serviceupdate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `word` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
sorgularını çalıştırın PhpMyadmin'de bunun yanında,
UPDATE user SET username = REPLACE (username,'?', 'ğ');
UPDATE user SET username = REPLACE (username,'y', 'ı');
UPDATE user SET username = REPLACE (username,'?', 'ş');
UPDATE user SET username = REPLACE (username,'?', 'Ğ');
UPDATE user SET username = REPLACE (username,'Y', 'İ');
UPDATE user SET username = REPLACE (username,'?', 'Ş');
çalıştırın,
UPDATE thread SET title = REPLACE (title,'?', 'ğ');
UPDATE thread SET title = REPLACE (title,'y', 'ı');
UPDATE thread SET title = REPLACE (title,'?', 'ş');
UPDATE thread SET title = REPLACE (title,'?', 'Ğ');
UPDATE thread SET title = REPLACE (title,'Y', 'İ');
UPDATE thread SET title = REPLACE (title,'?', 'Ş');,
UPDATE forum SET title = REPLACE (title,'?', 'ğ');
UPDATE forum SET title = REPLACE (title,'y', 'ı');
UPDATE forum SET title = REPLACE (title,'?', 'ş');
UPDATE forum SET title = REPLACE (title,'?', 'Ğ');
UPDATE forum SET title = REPLACE (title,'Y', 'İ');
UPDATE forum SET title = REPLACE (title,'?', 'Ş');
UPDATE forum SET title_clean = REPLACE (title_clean,'?', 'ğ');
UPDATE forum SET title_clean = REPLACE (title_clean,'y', 'ı');
UPDATE forum SET title_clean = REPLACE (title_clean,'?', 'ş');
UPDATE forum SET title_clean = REPLACE (title_clean,'?', 'Ğ');
UPDATE forum SET title_clean = REPLACE (title_clean,'Y', 'İ');
UPDATE forum SET title_clean = REPLACE (title_clean,'?', 'Ş');
UPDATE forum SET description = REPLACE (description,'?', 'ğ');
UPDATE forum SET description = REPLACE (description,'y', 'ı');
UPDATE forum SET description = REPLACE (description,'?', 'ş');
UPDATE forum SET description = REPLACE (description,'?', 'Ğ');
UPDATE forum SET description = REPLACE (description,'Y', 'İ');
UPDATE forum SET description = REPLACE (description,'?', 'Ş');
UPDATE forum SET description_clean = REPLACE (description_clean,'?', 'ğ');
UPDATE forum SET description_clean = REPLACE (description_clean,'y', 'ı');
UPDATE forum SET description_clean = REPLACE (description_clean,'?', 'ş');
UPDATE forum SET description_clean = REPLACE (description_clean,'?', 'Ğ');
UPDATE forum SET description_clean = REPLACE (description_clean,'Y', 'İ');
UPDATE forum SET description_clean = REPLACE (description_clean,'?', 'Ş');
UPDATE forum SET lastthread = REPLACE (lastthread,'?', 'ğ');
UPDATE forum SET lastthread = REPLACE (lastthread,'y', 'ı');
UPDATE forum SET lastthread = REPLACE (lastthread,'?', 'ş');
UPDATE forum SET lastthread = REPLACE (lastthread,'?', 'Ğ');
UPDATE forum SET lastthread = REPLACE (lastthread,'Y', 'İ');
UPDATE forum SET lastthread = REPLACE (lastthread,'?', 'Ş');
UPDATE post SET title = REPLACE (title,'y', 'ı');
UPDATE post SET title = REPLACE (title,'?', 'ş');
UPDATE post SET title = REPLACE (title,'?', 'Ğ');
UPDATE post SET title = REPLACE (title,'Y', 'İ');
UPDATE post SET title = REPLACE (title,'?', 'Ş');
UPDATE post SET pagetext = REPLACE (pagetext,'?', 'ğ');
UPDATE post SET pagetext = REPLACE (pagetext,'y', 'ı');
UPDATE post SET pagetext = REPLACE (pagetext,'?', 'ş');
UPDATE post SET pagetext = REPLACE (pagetext,'?', 'Ğ');
UPDATE post SET pagetext = REPLACE (pagetext,'Y', 'İ');
UPDATE post SET pagetext = REPLACE (pagetext,'?', 'Ş');
nanoeray

kişi bu mesajı beğendi.

#8
nanoeray nanoeray WM Aracı Kullanıcı
  • Üyelik 22.10.2012
  • Yaş/Cinsiyet 30 / E
  • Meslek Back-End Developer
  • Konum İzmir
  • Ad Soyad E** G**
  • Mesajlar 16
  • Beğeniler 7 / 1
  • Ticaret 1, (%100)
Teşekkürler :)
 

 

Vbulletin Rich Snipper
vBulletin Spam'dan Kurtulma - Video
wmaraci
wmaraci
Konuyu toplam 1 kişi okuyor. (0 kullanıcı ve 1 misafir)
 
Site Ayarları
  • Tema Seçeneği
  • Site Sesleri
  • Bildirimler
  • Özel Mesaj Al