[osflash] mySQL database problem with greek.

Sun Jan 6 15:58:00 PST 2008

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
> osflash at osflash.org
> http://osflash.org/mailman/listinfo/osflash_osflash.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://osflash.org/pipermail/osflash_osflash.org/attachments/20080106/d824b9f5/attachment.html 