Posted by Juliette on 11/03/00 11:56
jbk@ewebs.gr wrote:
> DID IT!!!! YEAH!!!!
> :-)
>
> just had to add
> mysql_query("SET NAMES greek")
> i dont exactly know what this does but it worked!
> Hehe....
> if anyone has the time to explain....
> Thanx!
> Ï <jbk@ewebs.gr> Ýãñáøå óôï ìÞíõìá news:ebq2aj$li6$1@aluminium.acn.gr...
>> Hello....
>>
>> I am trying do display data stored in mysql.. i get the data but because
>> it is(text) in greek it comes out like ?????????
>> i have changed the collation to greek_bin
>> both in the table as in the whole database...
>> I even tryied with the HTML tags of charset but even though i get these
>> ???????
>> to define: i got a table named fysc and two columns named "per" and
>> "askisi" as you see, i am searching in askisi to get results from per....
>>
>> my code:
>>
>> $sql = 'SELECT per FROM fysc WHERE askisi="fysc2" ';
>> //$what = mysql_query($sql);
>> $results = mysql_query($sql);
>> //$what = mysql_query($sql); ?>
>>
>> while ($row = mysql_fetch_array($results)) {
>> extract($row);
>> echo $per;
>> echo "<br>";
>> }
>>
>> ?>
>>
>>
>
>
You can find an explanation in this tutorial:
http://adviesenzo.nl/examples/php_mysql_charset_fix/
Navigation:
[Reply to this message]
|