Opencart Türkçe E-Ticaret » Programlama ve İşletim Sistemleri » Veritabanı » mySQL

Oscommerce DB Convert Collection

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,322
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,322
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
Yeni Cevap 


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

Foruma Git:


Bu konuyu görüntüleyen kullanıcı(lar): 1 Ziyaretçi
İletişim | Opencart Ana Sayfa | RSS Beslemesi