Loading ...
Sorry, an error occurred while loading the content.

Re: [php_greek] Re: convert ISO-8859-7 to utf-8 ??

Expand Messages
  • tilemachos anonymous
    mexri stigmis: xari sto backupdb() (http://www.silisoftware.com/) mporesa na exw ena dump me th swsth kwdikpoihsh (phpmyadmin den to ekane swsta). telika ta
    Message 1 of 9 , Jun 23, 2008
    • 0 Attachment
      mexri stigmis: xari sto backupdb()
      (http://www.silisoftware.com/) mporesa na exw ena dump
      me th swsth kwdikpoihsh (phpmyadmin den to ekane
      swsta). telika ta data mou htan se win-1253 (nai,
      noiw8w ili8ios).

      me to editpad pro to metetrepsa se utf8 opote 8a
      proxwrhsw apo edw kai pera gia na to balw sth basi,
      allaksw ola ta collation ktl.

      sas euxaristw olous.

      p.s. an psaxnei kaneis na allaksei ola ta collation me
      mia kinisi yparxei ena kalo class sto
      http://kb.siteground.com/article/How_to_change_the_collation_for_all_tables_in_a_mysql_databa.html



      --- Dimitris Botsis <dimbotsis@...> wrote:

      > Geia xara, soy proteinw 2 lyseis :
      >
      > 1) Anti gia Word mporeis na xrisimopoiiseis to
      > EditPad Lite. Kaneis dump
      > tin basi, fortwneis to text arxeio sto Editpad kai
      > apo to menu epilegeis
      > Convert codepage. 8a paiksei sigoura.
      >
      > 2) H server-side lysi :
      > Apo tin selida :
      > http://www.phpclasses.org/browse/package/1360.html,
      > katebase tin class ConvertCharset kai meta :
      > $FromCharset = "iso-8859-7";
      > $ToCharset = "utf8";
      > $text = new ConvertCharset();
      > $name= $text ->Convert($name, $FromCharset,
      > $ToCharset);
      >
      > Kali epityxia
      >
      >
      > go8p wrote:
      > > se euxaristo polu gia thn grigori apantisi.
      > > dustuxws to exw (ksana-)dokimasei sto parel8on
      > alla den doulepse.
      > >
      > > mipws yparxei alli idea? skeftomoun gia kati
      > server side
      > >
      > >
      > >
      > > --- In php_greek@yahoogroups.com, "Symeon
      > Charalabides" <symeon@...>
      > > wrote:
      > >> 1. Kaneis dump kai eheis oli sou ti vasi se
      > arheio (ISO)
      > >> 2. Anoigeis to arheio sto MS Word
      > >> 3. Save As -> Text (.txt)
      > >> 4. Otan se rotisei se ti character set to
      > theleis, vriskeis to UTF-8
      > > sti lista
      > >> 5. Fortoneis to kainourio sou dump sti MySQL
      > >> 6. Teleia.
      > >>
      > >>
      > >> Symeon Charalabides (cosmopolite trainee)
      > >> -----------------------------------------
      > >> http://www.systasis.com
      > >>
      > >>
      > >>> -------Original Message-------
      > >>> From: go8p <go8p@...>
      > >>> Subject: [php_greek] convert ISO-8859-7 to
      > utf-8 ??
      > >>> Sent: 23 Jun '08 19:14
      > >>>
      > >>> Kalispera sas,
      > >>>
      > >>> sth mysql basi mou ola ta dedomena einai se
      > ISO-8859-7 kai 8elw na ta
      > >>> metatrepsw (convert) se utf-8. gnwrizei kaneis
      > kanena scriptaki h
      > >>> kolpaki gia na ginei auto?
      > >>>
      > >>> euxarisw.
      > >>>
      > >>>
      > >>>
      > >>> ------------------------------------
      > >>>
      > >>> --
      > >>> ÅëëçíéêÞ PHP mailing listYahoo! Groups
      > Links
      > >>>
      > >>>
      > >>>
      > >>>
      > >
      > >
      > >
      > > ------------------------------------
      > >
      > > --
      > > ÅëëçíéêÞ PHP mailing listYahoo! Groups Links
      > >
      > >
      > >
      > >
      >
      >
      >
      > ------------------------------------
      >
      > --
      > ÅëëçíéêÞ PHP mailing listYahoo! Groups Links
      >
      >
      >
      >
      >
    • go8p
      telika doulepse opws to perigrafo parakatw. opws swsta eipate, xreiasthke na valw kai ta eksis meta to mysql connector. mysql_query( SET NAMES UTF8 );
      Message 2 of 9 , Jun 24, 2008
      • 0 Attachment
        telika doulepse opws to perigrafo parakatw. opws swsta eipate,
        xreiasthke na valw kai ta eksis meta to mysql connector.

        mysql_query('SET NAMES "UTF8"');
        mysql_query("SET collation_connection='utf8_general_ci'");
        mysql_query("SET collation_server='utf8_general_ci'");
        mysql_query("SET character_set_client='utf8'");
        mysql_query("SET character_set_connection='utf8'");
        mysql_query("SET character_set_results='utf8'");
        mysql_query("SET character_set_server='utf8'");





        --- In php_greek@yahoogroups.com, tilemachos anonymous <go8p@...> wrote:
        >
        > se euxaristw. to problhma mou einai oti egine allagi
        > sto server me apotelesma ta dedomena mou na einai se
        > iso-8859-7 enw to phpmyadmin ta dinei se utf-8. to
        > apotelesma einai oti den mporw na ta dw swsta para
        > mono an ta trabhksw apo php me encoding to iso. den
        > mporw na doulepsw apeu8eias sth bash alla mono mesw
        > kapoiou admin panel!
        >
        > tespa, euxaristw polu gia th syneisfora. elpizw kati
        > na brw
        >
        >
        >
        > --- Symeon Charalabides <symeon@...> wrote:
        >
        > > De gnorizo allo tropo, panta me Word to kano. Ehe
        > > yp'opsin pos
        > >
        > > 1. an douleveis me MySQL 5, prepei na eheis kanei
        > > enable UTF-8 support kata tin egatastasi kai
        > >
        > > 2. epeidi i MySQL 5 kanei default se kapoio
        > > latin-swedish-kati_tetoio, gia na travixeis ta
        > > apotelesmata sou kanonika se UTF-8, prepei na kaneis
        > >
        > > mysql_query("SET CHARACTER SET 'utf8'", $link);
        > >
        > > amesos meta to mysql_connect kai mysql_select_db.
        > > Koinos, prepei na einai to proto sou query kathe
        > > fora pou syndeesai.
        > >
        > > 3. A, prepei na eheis kai to antistoiho HTML header
        > > ;-)
        > >
        > >
        > > Symeon Charalabides (cosmopolite trainee)
        > > -----------------------------------------
        > > http://www.systasis.com
        > >
        > >
        > > > -------Original Message-------
        > > > From: go8p <go8p@...>
        > > > Subject: [php_greek] Re: convert ISO-8859-7 to
        > > utf-8 ??
        > > > Sent: 23 Jun '08 20:35
        > > >
        > > > se euxaristo polu gia thn grigori apantisi.
        > > > dustuxws to exw (ksana-)dokimasei sto parel8on
        > > alla den doulepse.
        > > >
        > > > mipws yparxei alli idea? skeftomoun gia kati
        > > server side
        > > >
        > > >
        > > >
        > > > --- In php_greek@yahoogroups.com, "Symeon
        > > Charalabides" <symeon@>
        > > > wrote:
        > > > >
        > > > > 1. Kaneis dump kai eheis oli sou ti vasi se
        > > arheio (ISO)
        > > > > 2. Anoigeis to arheio sto MS Word
        > > > > 3. Save As -> Text (.txt)
        > > > > 4. Otan se rotisei se ti character set to
        > > theleis, vriskeis to UTF-8
        > > > sti lista
        > > > > 5. Fortoneis to kainourio sou dump sti MySQL
        > > > > 6. Teleia.
        > > > >
        > > > >
        > > > > Symeon Charalabides (cosmopolite trainee)
        > > > > -----------------------------------------
        > > > > http://www.systasis.com
        > > > >
        > > > >
        > > > > >  -------Original Message-------
        > > > > >  From: go8p <go8p@>
        > > > > >  Subject: [php_greek] convert  ISO-8859-7
        > > to utf-8 ??
        > > > > >  Sent: 23 Jun '08 19:14
        > > > > >  
        > > > > >  Kalispera sas,
        > > > > >  
        > > > > >  sth mysql basi mou ola ta dedomena einai
        > > se ISO-8859-7 kai 8elw na ta
        > > > > >  metatrepsw (convert) se utf-8. gnwrizei
        > > kaneis kanena scriptaki h
        > > > > >  kolpaki gia na ginei auto?
        > > > > >  
        > > > > >  euxarisw.
        > > > > >  
        > > > > >  
        > > > > >  
        > > > > >  ------------------------------------
        > > > > >  
        > > > > >  --
        > > > > >  Ã…ëëçíéÃÂ�Þ PHP
        > > mailing listYahoo! Groups Links
        > > > > >  
        > > > > >  
        > > > > >  
        > > > > >
        > > > >
        > > >
        > > >
        > > >
        > > > ------------------------------------
        > > >
        > > > --
        > > > ÅëëçíéÃ�Ã� PHP mailing listYahoo! Groups
        > > Links
        > > >
        > > >
        > > >
        > > >
        > >
        > > ------------------------------------
        > >
        > > --
        > > ÅëëçíéêÞ PHP mailing listYahoo! Groups Links
        > >
        > >
        > >
        > >
        > >
        >
      Your message has been successfully submitted and would be delivered to recipients shortly.