Dear Nikos I did that I nothing. I am sending you also the php script I run: <meta http-equiv="Content-Type" content="text/html; charset=greek8">
<?php /* Connecting, selecting database */ $link = mysql_connect("localhost", "test", "") or die("Could not connect"); print "Connected successfully"; mysql_select_db("mysql") or die("Could not select database"); /* Performing SQL query */ $query = "SELECT * FROM test"; $result = mysql_query($query) or die("Query failed"); /* Printing results in HTML */ ?> <table> <?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ?> <tr> <?php foreach ($line as $col_value) {?> <td> <?php print $col_value; }?> </td> </tr> <?php } ?> </table> /* Free resultset */ <?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ?> George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -----Original Message----- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting '<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=iso-8859-7">' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: >Dear Nikos > >I run the below --defult-character-set=ISO-8859-7 and when I insert into the >database like > insert into test values('ÄÕÏ'); >when I select: > mysql> select * from test > -> ; > +------+ > | data | > +------+ > | åíá | > | ÅÍÁ | > | ÄÕÏ | > | äõï | > +------+ > 4 rows in set (0.04 sec) > >but the problem is in the Explorer pages where I get $%#$#$# > > >Any ideas, I work in Win200 system. > >George Nikoloudis > >INTRACOM S.A. >Telecom Business Support Systems > >19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 >GR 19002 Athens Fax: +30 10 667 97 97 >Greece Mob.: +30 972 03 60 06 > > > >-----Original Message----- >From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] >Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì >To: Nikoloudis George ([EMAIL PROTECTED]) >Cc: [EMAIL PROTECTED] >Subject: Re: Character Set Settings > > >Dear George, >I use to have problems with Greek Chars and after hundreds of hours of >testing i can assure you that the only solution is to compile Mysql using >as default char-set the Greek char-set. >Thus if your are using mysql for Linux you have to add to the ".configure" >parameters the following:(`--with-charset=greek' , >'--with-extra-charset=greek'). >Also if you have problems viewing greek characters from within a PHP page >maybe you have to define the correct encoding for the specific page. > >At 10:09 AM 9/25/2002 +0300, you wrote: > >Dear support > > > >I am trying to write data in the database in ISO-8859-7 character set. > >My Questions are: > >1) How do I configure MySQL to support this character set? > >2) I am using PHP to get these infornation from the database. Do I have to > >do something in my code to read teh data? > > > > > >Thenks a lot > > > >George Nikoloudis > > > >INTRACOM S.A. > >Telecom Business Support Systems > > > >19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 > >GR 19002 Athens Fax: +30 10 667 97 97 > >Greece Mob.: +30 972 03 60 06 > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >Georgiafentis Nikolaos >Project Manager >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >iTEL LTD >409 Vouliagmenis Ave. >Ilioupoli, 16346 >Tel: +30 10 9790050 >Fax: +30 10 9790051 Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php