Thanks again Ryan!
This theme about the specials chars drive me crazy!
I test all en 3 different servers, with php5 and 4 and checking the
data with phpMyAdmin and with two diffents local clients, cocoaMySQL
and YourSQL (Mac), and using the Terminal too. With the Terminal the
data look fine, but I'm scared because in all another clients I only
see garbage. Even from Windows and phpMyAdmin.
The MySQL have this confg:
charset: UTF-8 Unicode
collation: utf8_general_ci
and in the table and fields of my tests the collation is
latin_swedish_ci
I make the comparison of the service using Firebug between the two
modes (AMF0 -with remotingConnection patch- and AMF3) of AMFPHP 1.9.
I can't see any difference. But using AMF0 in AMFPHP 1.9 I can write
specials chars correctly in the database. This is really weird!! and
I would like make it to work using the ease way with AMF3.
So, I don't know if this is a problem in the beta version of AMFPHP
1.9, and I didn't see more people with a similar problem.
I test this with all type of data and with all diffents
setCharsetHandler in the gateway.php without luck.
regards
Rafael
On Mar 28, 2007, at 11:24 AM, Ryan Barrett wrote:
It sounds to me like a problem with differing character sets
between PHP and the database or the client you're using to connect
to the database.
I'd guess that both should be Latin-1 / Windows 1252..
You might get more info by looking at the communication between
flex and php, this is easy using Firefox and the latest version of
Firebug...
On 27/03/07, Rafael Guédez <[EMAIL PROTECTED]> wrote:
Thanks Ryan,
I tried with varchar and text datatype and I got the same problem.
For example: the char "á" look fine in the flex application, but in
the database is "á"
And my php class is like the old amfphp 1.2 without the method
table. If I use the same flex application with AMFPHP 1.9 and the
AMF0 remotingconnection package work fine and save the correct
chars in the DB. I'm using this old way for now,
like this:
http://www.adobe.com/devnet/flex/articles/flex2_amfphp_03.html
regards
Rafael
On Mar 27, 2007, at 11:01 AM, RadicalByte wrote:
--- In flexcoders@yahoogroups.com , Rafael Guédez <[EMAIL PROTECTED]>
wrote:
>
> Hello,
>
>
> I really don't know what to do, I'm using in the gateway:
>
>
> $gateway->setCharse tHandler( "none", "ISO-8859-1", "ISO-8859-1" );
>
>
> And running the application in the browser all the data look fine,
> but in the database this really write weird characters for special
> chars, and I need this data to see it in a normal flash web site.
>
>
> I don't know if this is a unsolved problem in this beta version.
Any
> idea?
>
>
> Flex 2, AMFPHP 1.9, MySQL 4.0.26 and PHP 5.0.4
>
>
> regards
>
>
> Rafael
>
Hi Rafael,
What datatype are the fields in your DB?
How're you handling the characters in PHP (as it doesn't support
unicode).
Cheers,
Ryan
--
Ryan
