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

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

Expand Messages
  • Dimitris Botsis
    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
    Message 1 of 9 , Jun 23, 2008
      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
      >
      >
      >
      >
    • tilemachos anonymous
      1) auto 8a eprepe na doulepse to problima me to dump sth periptwsi mou einai oti enw ta data einai iso, kanei dump se utf me apotelesma na bgainoun corrupted
      Message 2 of 9 , Jun 23, 2008
        1) auto 8a eprepe na doulepse to problima me to dump
        sth periptwsi mou einai oti enw ta data einai iso,
        kanei dump se utf me apotelesma na bgainoun corrupted
        (ax bre amerikanakia, ftinoi server alla sta charset
        den mas ta lete kala).

        2) to class 8a to dokimasw kai 8a sas pw

        euxaristw polu

        --- 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
        >
        >
        >
        >
        >
      • 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 3 of 9 , Jun 23, 2008
          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 4 of 9 , Jun 24, 2008
            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.