Thanks guys!
The advise you gave me were very usefull. I have added set nAMES and Set
Character set to utf-8 on both php files - the one that shows the entries
and the other that insert a new one. The show php works perfectly ;-) but...
the insert php doesnt seem to work again.... :-(
My php code when I insert thing in the mySQL database from flash is like
this..
<?php
mysql_pconnect (':/Applications/MAMP/tmp/mysql/mysql.sock', 'root', 'root');
mysql_select_db ("bookstore_db");
$newtitle =utf8_encode($_GET[newtitle]);;
$newdescription =$_GET['newdescription'];
$newpublisher =$_GET['newpublisher'];
$newyear =$_GET['newyear'];
$newpath =$_GET['newpath'];
mysql_query('SET NAMES UTF8);
mysql_query('SET CHARACTER SET UTF8');
$qResult = mysql_query ("INSERT INTO proteinoume_db VALUES
(
'','$newtitle','$newpublisher','$newyear',NOW(),'$newdescription','$newpath'
);");
?>
It seems to be a mix in the encodin, but I dont know what..
Any ideas??
2008/1/7, Chi Kin Lam <[EMAIL PROTECTED]>:
>
> HI, Panos,
>
> Is Keni, nice to see your e-mail.
>
>
> I think it is that you need to encode your database and all text fields in
> flash into UFT-8.
>
>
> I think the code is the same as Darren mentioned:
>
>
> SET NAMES UTF8;
>
>
> assign that at the beginning of your database.
>
>
> And I am just assuming that, you may want to check if the <head></head> on
> your html that host your flash has the right encoding:
>
>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=*UTF-8*" />
> <title>bla..bla..blablablaaaa</title>
> </head>
>
>
> hope I helped!!
>
>
> : ) Keni
>
> On 6 Jan 2008, at 15:48, PanosB B wrote:
>
> Hi everyone!
>
> I am now working on a seemingly easy project where I have an swf that
> reads a series of things from a mySQL database through .php in a textfield.
> It also has an input field where I can insert things inside the same
> database.
>
>
> When I insert and show english text from the database it all works fine.
> When I insert greek text in the database, it is shown in the flash with
> "?????" and if I look in the phpAdmin, the data isnt inserted corrrectly.
> Moreover, when I insert greek text throught the phpAdmin, it also doesnt
> show correctly in the flash.
> The encoding in the database is set to utf_unicode_ci.
>
> Any ideas of what the solution might be?
>
>
> Thanks,
> Panos
> _______________________________________________
> osflash mailing list
> [email protected]
> http://osflash.org/mailman/listinfo/osflash_osflash.org
>
>
>
>
> _______________________________________________
> osflash mailing list
> [email protected]
> http://osflash.org/mailman/listinfo/osflash_osflash.org
>
>
_______________________________________________
osflash mailing list
[email protected]
http://osflash.org/mailman/listinfo/osflash_osflash.org
