PayPal - Online ödeme yapmanın daha güvenli ve kolay yolu!
Yeni Cevap 
 
Konuyu Değerlendir
  • 0 Oy - 0 Ortalama
  • 1
  • 2
  • 3
  • 4
  • 5
Oscommerce DB Convert Collection
Yazar Mesaj
duzgun Çevrimdışı
Hizmetinizde
*******

Mesajlar: 2,323
Katılım: Jul 2008
Rep Puanı: 17
Mesaj: #1
Oscommerce DB Convert Collection
Veritabanı utf8 Karşılaştırması tanımı

Kod:
ALTER DATABASE `veritabanı-adı` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Tabloları utf8 Çevirmek

Kod:
ALTER TABLE `address_book` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `address_format` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `administrators` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `banners` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `banners_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `categories` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `categories_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `configuration` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `configuration_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `counter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `counter_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `countries` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `currencies` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customers_basket` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customers_basket_attributes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customers_info` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `geo_zones` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `languages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `manufacturers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `manufacturers_info` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `newsletters` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders_products` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders_products_attributes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders_products_download` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders_status` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders_status_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `orders_total` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pages_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_attributes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_attributes_download` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_notifications` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_options` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_options_values` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_options_values_to_products_options` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_to_categories` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reviews_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `specials` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tax_class` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tax_rates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `whos_online` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `zones` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `zones_to_geo_zones` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customers_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `specials_retail_prices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `products_attributes_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Veritabanı latin1 Karşılaştırması tanımı

Kod:
ALTER DATABASE `veritabanı-adı` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Tabloları latin1 Çevirmek

Kod:
ALTER TABLE `address_book` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `address_format` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `administrators` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `banners` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `banners_history` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `categories` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `categories_description` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `configuration` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `configuration_group` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `counter` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `counter_history` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `countries` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `currencies` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customers` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customers_basket` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customers_basket_attributes` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customers_info` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `geo_zones` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `languages` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `manufacturers` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `manufacturers_info` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `newsletters` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders_products` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders_products_attributes` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders_products_download` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders_status` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders_status_history` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `orders_total` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `pages` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `pages_description` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_attributes` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_attributes_download` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_description` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_notifications` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_options` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_options_values` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_options_values_to_products_options` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_to_categories` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `reviews` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `reviews_description` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `sessions` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `specials` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `tax_class` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `tax_rates` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `whos_online` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `zones` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `zones_to_geo_zones` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customers_groups` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `specials_retail_prices` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_groups` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `products_attributes_groups` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
02-02-2011 23:54
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
duzgun Çevrimdışı
Hizmetinizde
*******

Mesajlar: 2,323
Katılım: Jul 2008
Rep Puanı: 17
Mesaj: #2
RE: Oscommerce DB Convert Collection
PHP Kod:
<?php
$host
="localhost";
$user="root";
$pass="";
$db="";
$con mysql_connect($host,$user,$pass);
if (!
$con)
{
die(
'Could not connect: ' mysql_error());
}
mysql_select_db($db);
$sql "SHOW TABLES";
$result mysql_query($sql);
if (!
$result) {
    echo 
"DB Error, could not list tables\n";
    echo 
'MySQL Error: ' mysql_error();
    exit;
}
while (
$row mysql_fetch_row($result)) {
    echo 
"Converted: {$row[0]}\n";
    
mysql_query('ALTER TABLE `'.$row[0].'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;');
}
mysql_free_result($result);
mysql_close($con);
?>
18-10-2011 19:58
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
narkoz_39 Çevrimdışı
Member
***

Mesajlar: 36
Katılım: Aug 2012
Rep Puanı: 0
Mesaj: #3
RE: Oscommerce DB Convert Collection
teşekkurler

[url=http://www.frmwrz.org/forum-diger-program-icerikleri-310.html]program[/url]
15-08-2012 23:16
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
sergio_7 Çevrimdışı
Junior Member
**

Mesajlar: 9
Katılım: Apr 2012
Rep Puanı: 0
Mesaj: #4
RE: Oscommerce DB Convert Collection
Ya bu DB de character seti olayı bir turlu cozulemiyor. Ne yaparsak yapalım veritabanına her şekilde yanlış kaydediyor. Ben kaç defa patlattım soru işareti oldu geri de getiremiyorsun ondan sonra allahtan düzenli yedek alıyorum da o şekilde atlattık... Smile
03-09-2012 15:04
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
lucasduy Çevrimdışı
Junior Member
**

Mesajlar: 1
Katılım: May 2016
Rep Puanı: 0
Mesaj: #5
RE: Oscommerce DB Convert Collection
"The most important thing is to try and inspire people so that they can be great in whatever they want to do.
quotes about love
snake game
chinese food near me
panama papers
Fancam
(En son düzenleme: 06-05-2016 18:16 lucasduy.)
06-05-2016 18:13
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
Yeni Cevap 


Benzer Konular...
Konu: Yazar Cevaplar: Gösterim: Son Mesaj
  mySQL 5.5.x ve oscommerce snowbird 0 1,875 27-10-2011 11:38
Son Mesaj: snowbird

Foruma Git:


Bu konuyu görüntüleyen kullanıcı(lar): 1 Ziyaretçi