Problima me encodings se support system

[Παπαδογιαννάκης Βαγγέλης]

On Thu, 21 Jun 2001 12:23:31 +0300
Dimitrios Stasinopoulos <reverant at teilam.gr> wrote:

> Paides xaireto()
> 
> Exo ena problima to opoio einai ligo periergo.
> Mou exoun anathesei stin sxoli na ftiakso ena sistima
> gia support tou prosopikou. Epsaksa ligo sto freshmeat
> opou kai brika to ticketsmith, to opoio doulevei os eksis:
> Stelnei aftos pou thelei support se mia diefthnisi, eg.
> support_me at myorg.com kai to procmail otan lambanei to
> mail afto to stelnei se ena perl script, pou me tin
> seira tou to bazei mesa se mia mySql database. Istera
> to prosopiko pou asxoleitai me to support blepei ta
> mails pou kataxorountai san tickets mesa apo enan browser.
> Mexri edo ola kala, kai doulevei teleia. To problima einai
> os sinithos omos me ta ellinika. Sigkekrimena, exo stisei
> mai selida pou meso forms stelnei to email, mias kai oi
> perissoteroi stin sxoli oute email den kseroun na steiloun.
> Eno loipon ama po sto procmail na to kanei deliver sto mbox
> mou ta blepo ola omorfa kai oraia, kai ellinika ktl, ama
> kanei pipe to email stin database...gamietai to simpan.
> Endeiktika, to subject bgainei os eksis:
> 
> =?iso-8859-7?B?9OXz9DI=?=
> 
> Apo to opoio fainetai to exei ginei encoding me iso-8859-7
> To zitima einai pos mporo na "zitiso" meso ton forms na stelnetai
> to mail os plain text, kai oxi os encoded me charset tade?
> Mesa stin selida pou einai i forma, exo balei to tag:
> 
> <form METHOD="POST" ACTION="mailto:support_me at myorg.com" ENCTYPE="text/plain">
> 
> alla parola afta den pairno tipota. I moni lisi pou mporo na
> skefto einai bebaia mi-pragmatopoiisimi (encoding se ola ta
> outlook plain text). Kserei kaneis tipota allo pou mporei
> na boithisei?
> 
> Efxaristo prokatabolika
> 
> --
> The Reverant
> (Dimitrios Stasinopoulos)

gia ellinika sti mysql, prepei na kaneis edit to safemysql (kati tetoio?) kai na arxizeis meso aftou tin mysql kapos etsi.

/usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysql.pid --default-character-set=greek --user=mysql &

(se mia grami, i me \ sto telos tis protis)
kai 8a exeis elliniko sorting-searching, k.lp. stin mysql.

Alla afto pou prepei na kaneis, den einai afto :)

i katiteri lisi einai i forma na stelnei se ena script, kai afto na pigainei na grafei apef8eias se basi dedomenon, i an ta 8es me email na to stelnei to script me mail

se sintomia:
<form method=post action=koko.php>
<input type=text name=whois>
<input type=text name=hismail>
<input type=text name=subject>
<input type=text name=problem>
<input type=submit>
</form>

--koko.php--
<?php
mail('you at where',$subject,"$whois asked: $problem","From: $hismail\nContent-Type: text/plain; charset=iso-8859-7");
(edo mia mysql_query entoli, gia na min ta kaneis pipe :) );
?>
An 8es boithia kai stin query entoli, steile prosopiko.
elpizo na voithisa.

Vagelis Papadogiannakis
http://www.wise.gr
papas at wise.gr