مشكلة في ترميز الجدول tag بيظهر كلام مثل الصيني
 

أخواني الأفاضل السلام عليكم

هناك مشكلة في الجدول tag عندما أريد تغيير ترميزة إلي uft8 من الترميز latin1

عند الدخول إلي اوامر قاعدة البيانات عن طريق phpmyadmin ووضع هذا الكود لتغيير الترميز

ALTER TABLE `tag` CONVERT TO CHARACTER SET `utf8`;

بيظهر لي هذا الكلام

#1062 - Duplicate entry 'ÈäÇÊ' for key 'tagtext'

علماُ بأني قمت بتغغير كافة الجداول و تمت العملية بنجاح عدا الجدول tag

و هذه الجداول الموجودة بقاعدة بياناتي

Table Action Records 1 Type Collation Size Overhead
access 34 MyISAM utf8_general_ci 2.3 KiB -
adminhelp 1*663 MyISAM utf8_general_ci 171.0 KiB -
administrator 2 MyISAM utf8_general_ci 2.1 KiB -
adminlog 2*796 MyISAM utf8_general_ci 179.8 KiB -
adminmessage 2 MyISAM utf8_general_ci 10.2 KiB -
adminutil 2 MyISAM utf8_general_ci 73.1 KiB -
album 10 MyISAM utf8_general_ci 3.7 KiB -
albumpicture 10 MyISAM utf8_general_ci 4.1 KiB -
albumupdate 0 MyISAM utf8_general_ci 1.0 KiB -
announcement 4 MyISAM utf8_general_ci 7.7 KiB -
announcementread 58 MyISAM utf8_general_ci 3.5 KiB -
attachment 117 MyISAM utf8_general_ci 2.9 MiB -
attachmentpermission 0 MyISAM utf8_general_ci 1.0 KiB -
attachmenttype 12 MyISAM utf8_general_ci 3.7 KiB -
attachmentviews 0 MyISAM utf8_general_ci 1.0 KiB -
avatar 41 MyISAM utf8_general_ci 3.6 KiB -
bbcode 25 MyISAM utf8_general_ci 11.3 KiB -
bookmarksite 4 MyISAM utf8_general_ci 2.5 KiB -
calendar 1 MyISAM utf8_general_ci 3.1 KiB -
calendarcustomfield 0 MyISAM utf8_general_ci 1.0 KiB -
calendarmoderator 0 MyISAM utf8_general_ci 1.0 KiB -
calendarpermission 0 MyISAM utf8_general_ci 1.0 KiB -
cpsession 10 MyISAM utf8_general_ci 2.5 KiB -
cron 17 MyISAM utf8_general_ci 7.6 KiB -
cronlog 2*023 MyISAM utf8_general_ci 126.3 KiB -
customavatar 122 MyISAM utf8_general_ci 2.3 MiB -
customprofilepic 28 MyISAM utf8_general_ci 111.7 KiB -
datastore 32 MyISAM utf8_general_ci 337.1 KiB -
deletionlog 2*381 MyISAM utf8_general_ci 171.0 KiB -
discussion 17 MyISAM utf8_general_ci 3.9 KiB -
discussionread 0 MyISAM utf8_general_ci 1.0 KiB -
editlog 11*905 MyISAM utf8_general_ci 668.7 KiB -
event 10 MyISAM utf8_general_ci 7.1 KiB -
externalcache 7 MyISAM utf8_general_ci 337.5 KiB -
faq 42 MyISAM utf8_general_ci 10.8 KiB -
forum 83 MyISAM utf8_general_ci 30.5 KiB -
forumpermission 31 MyISAM utf8_general_ci 3.4 KiB -
forumprefixset 0 MyISAM utf8_general_ci 1.0 KiB -
forumread 0 MyISAM utf8_general_ci 1.0 KiB -
groupmessage 168 MyISAM utf8_general_ci 49.3 KiB -
groupmessage_hash 1*241 MyISAM utf8_general_ci 130.0 KiB -
groupread 0 MyISAM utf8_general_ci 1.0 KiB -
holiday 0 MyISAM utf8_general_ci 2.0 KiB -
humanverify 6 MyISAM utf8_general_ci 3.3 KiB -
hvanswer 1 MyISAM utf8_general_ci 3.0 KiB -
hvquestion 1 MyISAM utf8_general_ci 2.0 KiB -
icon 38 MyISAM utf8_general_ci 3.5 KiB -
imagecategory 3 MyISAM utf8_general_ci 2.1 KiB -
imagecategorypermission 0 MyISAM utf8_general_ci 1.0 KiB -
infraction 192 MyISAM utf8_general_ci 35.3 KiB -
infractionban 0 MyISAM utf8_general_ci 1.0 KiB -
infractiongroup 0 MyISAM utf8_general_ci 1.0 KiB -
infractionlevel 4 MyISAM utf8_general_ci 2.1 KiB -
language 1 MyISAM utf8_general_ci 528.5 KiB -
mailqueue 0 MyISAM utf8_general_ci 1.0 KiB -
moderation 88 MyISAM utf8_general_ci 4.5 KiB -
moderator 37 MyISAM utf8_general_ci 3.6 KiB -
moderatorlog 0 MyISAM utf8_general_ci 1.0 KiB -
notice 0 MyISAM utf8_general_ci 1.0 KiB -
noticecriteria 0 MyISAM utf8_general_ci 4.0 KiB -
noticedismissed 0 MyISAM utf8_general_ci 1.0 KiB -
passwordhistory 40*335 MyISAM utf8_general_ci 2.1 MiB -
paymentapi 7 MyISAM utf8_general_ci 4.0 KiB -
paymentinfo 0 MyISAM utf8_general_ci 1.0 KiB -
paymenttransaction 0 MyISAM utf8_general_ci 4.0 KiB -
phrase 17*610 MyISAM utf8_general_ci 4.0 MiB -
phrasetype 65 MyISAM utf8_general_ci 6.2 KiB -
picture 10 MyISAM utf8_general_ci 604.3 KiB -
picturecomment 1 MyISAM utf8_general_ci 4.1 KiB -
picturecomment_hash 2 MyISAM utf8_general_ci 3.1 KiB -
plugin 0 MyISAM utf8_general_ci 1.0 KiB -
pm 130*406 MyISAM utf8_general_ci 6.9 MiB -
pmreceipt 1*330 MyISAM utf8_general_ci 139.9 KiB -
pmtext 128*426 MyISAM utf8_general_ci 77.9 MiB -
pmthrottle 0 MyISAM utf8_general_ci 1.0 KiB -
podcast 0 MyISAM utf8_general_ci 1.0 KiB -
podcastitem 0 MyISAM utf8_general_ci 1.0 KiB -
poll 134 MyISAM utf8_general_ci 28.0 KiB -
pollvote 1*260 MyISAM utf8_general_ci 104.8 KiB -
post 629*052 MyISAM utf8_general_ci 558.3 MiB -
postedithistory 25*309 MyISAM utf8_general_ci 44.6 MiB -
posthash 10 MyISAM utf8_general_ci 4.1 KiB -
postindex 0 MyISAM utf8_general_ci 1.0 KiB -
postlog 42 MyISAM utf8_general_ci 16.8 KiB -
postparsed 24 MyISAM utf8_general_ci 46.6 KiB -
prefix 0 MyISAM utf8_general_ci 1.0 KiB -
prefixpermission 0 MyISAM utf8_general_ci 1.0 KiB -
prefixset 0 MyISAM utf8_general_ci 1.0 KiB -
product 0 MyISAM utf8_general_ci 1.0 KiB -
productcode 0 MyISAM utf8_general_ci 1.0 KiB -
productdependency 0 MyISAM utf8_general_ci 1.0 KiB -
profileblockprivacy 226 MyISAM utf8_general_ci 20.9 KiB -
profilefield 7 MyISAM utf8_general_ci 5.3 KiB -
profilefieldcategory 0 MyISAM utf8_general_ci 1.0 KiB -
profilevisitor 21*294 MyISAM utf8_general_ci 1.0 MiB -
ranks 64 MyISAM utf8_general_ci 5.3 KiB -
regimage 0 MyISAM utf8_general_ci 1.0 KiB -
reminder 0 MyISAM utf8_general_ci 1.0 KiB -
reputation 1*834 MyISAM utf8_general_ci 200.3 KiB -
reputationlevel 18 MyISAM utf8_general_ci 3.2 KiB -
rssfeed 0 MyISAM utf8_general_ci 1.0 KiB -
rsslog 0 MyISAM utf8_general_ci 1.0 KiB -
search 0 MyISAM utf8_general_ci 4.0 KiB -
session 833 MyISAM utf8_general_ci 1.1 MiB -
setting 399 MyISAM utf8_general_ci 59.1 KiB -
settinggroup 47 MyISAM utf8_general_ci 3.3 KiB -
sigparsed 8 MyISAM utf8_general_ci 4.2 KiB -
sigpic 46 MyISAM utf8_general_ci 3.4 MiB -
smilie 71 MyISAM utf8_general_ci 48.2 KiB -
socialgroup 31 MyISAM utf8_general_ci 25.4 KiB -
socialgroupcategory 1 MyISAM utf8_general_ci 3.0 KiB -
socialgroupicon 0 MyISAM utf8_general_ci 1.0 KiB -
socialgroupmember 249 MyISAM utf8_general_ci 17.4 KiB -
socialgrouppicture 1 MyISAM utf8_general_ci 4.0 KiB -
spamlog 0 MyISAM utf8_general_ci 1.0 KiB -
stats 684 MyISAM utf8_general_ci 20.4 KiB -
strikes 0 MyISAM utf8_general_ci 1.0 KiB -
style 4 MyISAM utf8_general_ci 118.6 KiB -
subscribediscussion 0 MyISAM utf8_general_ci 1.0 KiB -
subscribeevent 2 MyISAM utf8_general_ci 4.0 KiB -
subscribeforum 42 MyISAM utf8_general_ci 4.5 KiB -
subscribegroup 0 MyISAM utf8_general_ci 1.0 KiB -
subscribethread 29*902 MyISAM utf8_general_ci 1.9 MiB -
subscription 0 MyISAM utf8_general_ci 1.0 KiB -
subscriptionlog 0 MyISAM utf8_general_ci 1.0 KiB -
subscriptionpermission 0 MyISAM utf8_general_ci 1.0 KiB -
tachyforumcounter 0 MyISAM utf8_general_ci 1.0 KiB -
tachyforumpost 0 MyISAM utf8_general_ci 1.0 KiB -
tachythreadcounter 0 MyISAM utf8_general_ci 1.0 KiB -
tachythreadpost 0 MyISAM utf8_general_ci 1.0 KiB -
tag 37*687 MyISAM latin1_swedish_ci 1.7 MiB -
tagsearch 4*941 MyISAM utf8_general_ci 94.4 KiB -
tagthread 97*029 MyISAM utf8_general_ci 5.4 MiB -
template 744 MyISAM utf8_general_ci 3.6 MiB -
templatehistory 2 MyISAM utf8_general_ci 31.8 KiB -
thread 46*278 MyISAM utf8_general_ci 14.3 MiB -
threadrate 4*517 MyISAM utf8_general_ci 393.7 KiB -
threadread 0 MyISAM utf8_general_ci 1.0 KiB -
threadredirect 0 MyISAM utf8_general_ci 1.0 KiB -
threadviews 46 MyISAM utf8_general_ci 2.3 KiB -
upgradelog 50 MyISAM utf8_general_ci 5.2 KiB -
user 40*096 MyISAM utf8_general_ci 9.9 MiB -
useractivation 5 MyISAM utf8_general_ci 3.3 KiB -
userban 399 MyISAM utf8_general_ci 30.0 KiB -
userchangelog 5*765 MyISAM utf8_general_ci 947.0 KiB -
usercss 0 MyISAM utf8_general_ci 1.0 KiB -
usercsscache 0 MyISAM utf8_general_ci 1.0 KiB -
userfield 40*096 MyISAM utf8_general_ci 2.2 MiB -
usergroup 13 MyISAM utf8_general_ci 4.8 KiB -
usergroupleader 0 MyISAM utf8_general_ci 1.0 KiB -
usergrouprequest 0 MyISAM utf8_general_ci 1.0 KiB -
userlist 11*214 MyISAM utf8_general_ci 597.5 KiB -
usernote 1 MyISAM utf8_general_ci 4.4 KiB -
userpromotion 0 MyISAM utf8_general_ci 1.0 KiB -
usertextfield 40*096 MyISAM utf8_general_ci 2.1 MiB -
usertitle 5 MyISAM utf8_general_ci 5.7 KiB -
visitormessage 9*756 MyISAM utf8_general_ci 2.0 MiB -
visitormessage_hash 0 MyISAM utf8_general_ci 1.0 KiB -
word 0 MyISAM utf8_general_ci 1.0 KiB -
159 table(s) Sum 1*391*795 MyISAM utf8_general_ci 754.2 MiB 0 B


ما هو الحل أخواني و هل إذا حدفت الجدول tag من القاعدة يؤثر عليها أما لا :nosweat:

و الله أريد حل ضروري و لكم جزيل الشكر و الدعاء :)