convert ISO-8859-7 to utf-8 ??

[go8p]

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.

[Symeon Charalabides]

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
>  
>  
>  
>  

[go8p]

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@..., "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
> >  
> >  
> >  
> >
>

[Symeon Charalabides]

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@..., "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
>  
>  
>  
>  

[go8p]

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@..., "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
>
>
>
>
>

     

[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 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@..., "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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php_greek/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php_greek/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:php_greek-digest@...
    mailto:php_greek-fullfeatured@...

<*> To unsubscribe from this group, send an email to:
    php_greek-unsubscribe@...

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

[go8p]

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@..., "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]

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@..., "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"');
  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@..., 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@..., "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
> >
> >
> >
> >
> >
>