Re: [phpMyAdmin Developers] Problem of qrqbic langage
abrar dogar <[email protected]> Sun, 24 Mar 2019 12:37:19 +0500
| Newsgroups | gmane.comp.php.phpmyadmin.devel |
|---|---|
| Message-ID | <[email protected]> |
--===============6962369783300704439== Content-Type: multipart/alternative; boundary="_E2DE2A92-65AA-4D0D-B95B-810574362C56_" --_E2DE2A92-65AA-4D0D-B95B-810574362C56_ Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" To insert Arabic Data manually into your Phpmyadmin. First you check either your database , table and column name is utf8 set or= not. If these are not set to utf8 then first you set it then you may inser= t arabic data into you db table. For Columns: SELECT character_set_name FROM information_schema.`COLUMNS` C WHERE table_schema =3D "schemaname" AND table_name =3D "tablename" AND column_name =3D "columnname"; You may easily set utf8 to your tables if you are using SQLYog. Just right click on db, table, column name and click on alter option and se= t to Database Chartset =3D utf8 Database Collation =3D utf8_general_ci . Just Enjoy .... Go to this link for reference=20 Regards and Best Wishes, Abrar Ahmad Pakistan From: rjiba aymen Sent: Saturday, March 23, 2019 10:00 PM To: [email protected] Subject: [phpMyAdmin Developers] Problem of qrqbic langage Hello=C2=A0, I have a Problem in phpMyAdmin which the the arabic langage It Save like Th= is =E2=80=98=C3=99?=C3=99?=C3=98=C2=AA=C3=98=C2=A8 =C3=98=C2=A7=C3=99?=C3= =98=C2=B6=C3=98=C2=A8=C3=98=C2=B7=E2=80=99 Under a centos server Thanks Provenance=C2=A0: Courrier pour Windows 10 --_E2DE2A92-65AA-4D0D-B95B-810574362C56_ Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="utf-8" <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc= hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of= fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta ht= tp-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta name= =3DGenerator content=3D"Microsoft Word 15 (filtered medium)"><style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:inherit;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;} pre {mso-style-priority:99; mso-style-link:"HTML Preformatted Char"; margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} span.HTMLPreformattedChar {mso-style-name:"HTML Preformatted Char"; mso-style-priority:99; mso-style-link:"HTML Preformatted"; font-family:"Courier New";} span.kwd {mso-style-name:kwd;} span.pln {mso-style-name:pln;} span.pun {mso-style-name:pun;} span.str {mso-style-name:str;} .MsoChpDefault {mso-style-type:export-only;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} --></style></head><body lang=3DEN-US link=3Dblue vlink=3D"#954F72"><div cla= ss=3DWordSection1><p class=3DMsoNormal style=3D'mso-margin-top-alt:1.5pt;ma= rgin-right:0in;margin-bottom:1.5pt;margin-left:0in;background:white;vertica= l-align:baseline'><span style=3D'font-size:11.5pt;font-family:"inherit",ser= if;color:#242729'>To insert Arabic Data manually into your Phpmyadmin.</spa= n><span style=3D'font-size:10.0pt;font-family:"inherit",serif;color:#242729= '><o:p></o:p></span></p><div style=3D'margin-bottom:3.75pt;font-style:inher= it;font-variant:inherit;font-weight:inherit;font-stretch: inherit;box-sizin= g: inherit;overflow-wrap: break-word'><p style=3D'mso-margin-top-alt:0in;ma= rgin-right:0in;margin-bottom:12.0pt;margin-left:0in;background:white;vertic= al-align:baseline'><span style=3D'font-size:11.5pt;font-family:"inherit",se= rif;color:#242729'>First you check either your database , table and column = name is utf8 set or not. If these are not set to utf8 then first you set it= then you may insert arabic data into you db table.<o:p></o:p></span></p><d= iv><p style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt= ;margin-left:0in;background:white;vertical-align:baseline'><span style=3D'f= ont-size:11.5pt;font-family:"Arial",sans-serif;color:#242729'>For Columns:<= o:p></o:p></span></p><pre style=3D'background:#EFF0F1;vertical-align:baseli= ne;font-variant-ligatures: normal;font-variant-caps: normal;font-variant-nu= meric: inherit;font-variant-east-asian: inherit;font-stretch: inherit;line-= height:inherit;box-sizing: inherit;max-height: 600px;border-radius: 3px;ove= rflow-wrap: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;text= -decoration-style: initial;text-decoration-color: initial;overflow:auto;wor= d-spacing:0px'><span class=3Dkwd><span style=3D'font-family:"inherit",serif= ;color:#101094;border:none windowtext 1.0pt;padding:0in;background:#EFF0F1'= >SELECT</span></span><span class=3Dpln><span style=3D'font-family:"inherit"= ,serif;color:#303336;border:none windowtext 1.0pt;padding:0in;background:#E= FF0F1'> character_set_name </span></span><span class=3Dkwd><span style=3D'f= ont-family:"inherit",serif;color:#101094;border:none windowtext 1.0pt;paddi= ng:0in;background:#EFF0F1'>FROM</span></span><span class=3Dpln><span style= =3D'font-family:"inherit",serif;color:#303336;border:none windowtext 1.0pt;= padding:0in;background:#EFF0F1'> information_schema</span></span><span clas= s=3Dpun><span style=3D'font-family:"inherit",serif;color:#303336;border:non= e windowtext 1.0pt;padding:0in;background:#EFF0F1'>.`</span></span><span cl= ass=3Dpln><span style=3D'font-family:"inherit",serif;color:#303336;border:n= one windowtext 1.0pt;padding:0in;background:#EFF0F1'>COLUMNS</span></span><= span class=3Dpun><span style=3D'font-family:"inherit",serif;color:#303336;b= order:none windowtext 1.0pt;padding:0in;background:#EFF0F1'>`</span></span>= <span class=3Dpln><span style=3D'font-family:"inherit",serif;color:#303336;= border:none windowtext 1.0pt;padding:0in;background:#EFF0F1'> C<o:p></o:p><= /span></span></pre><pre style=3D'background:#EFF0F1;vertical-align:baseline= '><span class=3Dkwd><span style=3D'font-family:"inherit",serif;color:#10109= 4;border:none windowtext 1.0pt;padding:0in;background:#EFF0F1'>WHERE</span>= </span><span class=3Dpln><span style=3D'font-family:"inherit",serif;color:#= 303336;border:none windowtext 1.0pt;padding:0in;background:#EFF0F1'> table_= schema </span></span><span class=3Dpun><span style=3D'font-family:"inherit"= ,serif;color:#303336;border:none windowtext 1.0pt;padding:0in;background:#E= FF0F1'>=3D</span></span><span class=3Dpln><span style=3D'font-family:"inher= it",serif;color:#303336;border:none windowtext 1.0pt;padding:0in;background= :#EFF0F1'> </span></span><span class=3Dstr><span style=3D'font-family:"inhe= rit",serif;color:#7D2727;border:none windowtext 1.0pt;padding:0in;backgroun= d:#EFF0F1'>"schemaname"</span></span><span class=3Dpln><span styl= e=3D'font-family:"inherit",serif;color:#303336;border:none windowtext 1.0pt= ;padding:0in;background:#EFF0F1'><o:p></o:p></span></span></pre><pre style= =3D'background:#EFF0F1;vertical-align:baseline'><span class=3Dpln><span sty= le=3D'font-family:"inherit",serif;color:#303336;border:none windowtext 1.0p= t;padding:0in;background:#EFF0F1'> =C2=A0</span></span><span class=3Dkwd><s= pan style=3D'font-family:"inherit",serif;color:#101094;border:none windowte= xt 1.0pt;padding:0in;background:#EFF0F1'>AND</span></span><span class=3Dpln= ><span style=3D'font-family:"inherit",serif;color:#303336;border:none windo= wtext 1.0pt;padding:0in;background:#EFF0F1'> table_name </span></span><span= class=3Dpun><span style=3D'font-family:"inherit",serif;color:#303336;borde= r:none windowtext 1.0pt;padding:0in;background:#EFF0F1'>=3D</span></span><s= pan class=3Dpln><span style=3D'font-family:"inherit",serif;color:#303336;bo= rder:none windowtext 1.0pt;padding:0in;background:#EFF0F1'> </span></span><= span class=3Dstr><span style=3D'font-family:"inherit",serif;color:#7D2727;b= order:none windowtext 1.0pt;padding:0in;background:#EFF0F1'>"tablename= "</span></span><span class=3Dpln><span style=3D'font-family:"inherit",= serif;color:#303336;border:none windowtext 1.0pt;padding:0in;background:#EF= F0F1'><o:p></o:p></span></span></pre><pre style=3D'background:#EFF0F1;verti= cal-align:baseline'><span class=3Dpln><span style=3D'font-family:"inherit",= serif;color:#303336;border:none windowtext 1.0pt;padding:0in;background:#EF= F0F1'> =C2=A0</span></span><span class=3Dkwd><span style=3D'font-family:"in= herit",serif;color:#101094;border:none windowtext 1.0pt;padding:0in;backgro= und:#EFF0F1'>AND</span></span><span class=3Dpln><span style=3D'font-family:= "inherit",serif;color:#303336;border:none windowtext 1.0pt;padding:0in;back= ground:#EFF0F1'> column_name </span></span><span class=3Dpun><span style=3D= 'font-family:"inherit",serif;color:#303336;border:none windowtext 1.0pt;pad= ding:0in;background:#EFF0F1'>=3D</span></span><span class=3Dpln><span style= =3D'font-family:"inherit",serif;color:#303336;border:none windowtext 1.0pt;= padding:0in;background:#EFF0F1'> </span></span><span class=3Dstr><span styl= e=3D'font-family:"inherit",serif;color:#7D2727;border:none windowtext 1.0pt= ;padding:0in;background:#EFF0F1'>"columnname"</span></span><span = class=3Dpun><span style=3D'font-family:"inherit",serif;color:#303336;border= :none windowtext 1.0pt;padding:0in;background:#EFF0F1'>;</span></span><span= style=3D'font-family:Consolas;color:#393318'><o:p></o:p></span></pre></div= ><p style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;m= argin-left:0in;background:white;vertical-align:baseline'><span style=3D'fon= t-size:11.5pt;font-family:"inherit",serif;color:#242729'><o:p> </o:p><= /span></p><div><p style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-b= ottom:12.0pt;margin-left:0in;background:white;vertical-align:baseline'><spa= n style=3D'font-size:11.5pt;font-family:"Arial",sans-serif;color:#242729'>Y= ou may easily set utf8 to your tables if you are using SQLYog.<o:p></o:p></= span></p><p style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:= 12.0pt;margin-left:0in;background:white;vertical-align:baseline;font-varian= t-ligatures: normal;font-variant-caps: normal;font-variant-numeric: inherit= ;font-variant-east-asian: inherit;font-stretch: inherit;line-height:inherit= ;box-sizing: inherit;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;te= xt-decoration-style: initial;text-decoration-color: initial;word-spacing:0p= x'><span style=3D'font-size:11.5pt;font-family:"Arial",sans-serif;color:#24= 2729'>Just right click on db, table, column name and click on alter option = and set to<o:p></o:p></span></p><p style=3D'mso-margin-top-alt:0in;margin-r= ight:0in;margin-bottom:12.0pt;margin-left:0in;background:white;vertical-ali= gn:baseline;font-variant-ligatures: normal;font-variant-caps: normal;font-v= ariant-numeric: inherit;font-variant-east-asian: inherit;font-stretch: inhe= rit;line-height:inherit;box-sizing: inherit;orphans: 2;widows: 2;-webkit-te= xt-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: = initial;word-spacing:0px'><span style=3D'font-size:11.5pt;font-family:"Aria= l",sans-serif;color:#242729'>Database Chartset =3D utf8 Database Collation = =3D utf8_general_ci .<o:p></o:p></span></p><p style=3D'mso-margin-top-alt:0= in;margin-right:0in;margin-bottom:12.0pt;margin-left:0in;background:white;v= ertical-align:baseline;font-variant-ligatures: normal;font-variant-caps: no= rmal;font-variant-numeric: inherit;font-variant-east-asian: inherit;font-st= retch: inherit;line-height:inherit;box-sizing: inherit;orphans: 2;widows: 2= ;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decorat= ion-color: initial;word-spacing:0px'><span style=3D'font-size:11.5pt;font-f= amily:"Arial",sans-serif;color:#242729'>Just Enjoy ....<o:p></o:p></span></= p></div><p style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:1= 2.0pt;margin-left:0in;background:white;vertical-align:baseline'><span style= =3D'font-size:11.5pt;font-family:"inherit",serif;color:#242729'><a href=3D"= https://stackoverflow.com/questions/6859018/save-data-in-arabic-in-mysql-da= tabase">Go to this link for reference</a> <o:p></o:p></span></p></div><p cl= ass=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal><o:p> </o:p>= </p><p class=3DMsoNormal>Regards and Best Wishes,<o:p></o:p></p><p class=3D= MsoNormal><b>Abrar Ahmad<o:p></o:p></b></p><p class=3DMsoNormal><b>Pakistan= <o:p></o:p></b></p><p class=3DMsoNormal><o:p> </o:p></p><div style=3D'= mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padd= ing:3.0pt 0in 0in 0in'><p class=3DMsoNormal style=3D'border:none;padding:0i= n'><b>From: </b><a href=3D"mailto:[email protected]">rjiba aymen</a><br><b= >Sent: </b>Saturday, March 23, 2019 10:00 PM<br><b>To: </b><a href=3D"mailt= o:[email protected]">[email protected]</a><br><b>Subject: <= /b>[phpMyAdmin Developers] Problem of qrqbic langage</p></div><p class=3DMs= oNormal><o:p> </o:p></p><p class=3DMsoNormal><span lang=3DFR>Hello&nbs= p;,<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DFR>I have a Prob= lem in phpMyAdmin which the the arabic langage It Save like This =E2=80=98= =C3=99?=C3=99?=C3=98=C2=AA=C3=98=C2=A8 =C3=98=C2=A7=C3=99?=C3=98=C2=B6=C3= =98=C2=A8=C3=98=C2=B7=E2=80=99 Under a centos server<o:p></o:p></span></p><= p class=3DMsoNormal><span lang=3DFR><br></span><span lang=3DFR style=3D'fon= t-size:22.0pt;font-family:"Arial",sans-serif;color:#212121;background:white= '>Thanks</span><o:p></o:p></p><p class=3DMsoNormal><span lang=3DFR><o:p>&nb= sp;</o:p></span></p><p class=3DMsoNormal><span lang=3DFR>Provenance : = <a href=3D"https://go.microsoft.com/fwlink/?LinkId=3D550986">Courrier</a> p= our Windows 10<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DFR><o= :p> </o:p></span></p><p class=3DMsoNormal><o:p> </o:p></p></div><= /body></html>= --_E2DE2A92-65AA-4D0D-B95B-810574362C56_-- --===============6962369783300704439== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KRGV2ZWxvcGVy cyBtYWlsaW5nIGxpc3QKRGV2ZWxvcGVyc0BwaHBteWFkbWluLm5ldApodHRwczovL2xpc3RzLnBo cG15YWRtaW4ubmV0L21haWxtYW4vbGlzdGluZm8vZGV2ZWxvcGVycwo= --===============6962369783300704439==--