Re: Bug #13839 Updated: mysql_db_query does converts EURO symbol
mysql_db_query() doesn't touch the data. Plese post the smallest
possible reproduceable example against CVS or a snapshot from
snaps.php.net or RC (php.net/~zeev/ || php.net/~ssb)
- Markus
On Mon, Oct 29, 2001 at 12:30:19PM -0000, Martin_Rauch@web.de wrote :
> ID: 13839
> User updated by: Martin_Rauch@web.de
> Reported By: Martin_Rauch@web.de
> Status: Bogus
> Bug Type: MySQL related
> Operating System: Linux 2.2.18
> PHP Version: 4.0.6
> New Comment:
>
> It is not the problem of the character set. It is a matter of changing the data before it gets
> inserted into the database.
> example:
>
> the orginal string is "€"
> the string that gets inserted by mysql_db_query is: "€"
>
> -> the character "&" gets encoded into "&"!
>
> Only the orginal string "€" displays an EURO character with the browser if
> you read it from the database
> with php and display it in a HTML page.
>
> Is there a way to tell mysql_db_query() not to touch the string before inserting it into the
> database??
>
> Thanks
> Martin
>
> Previous Comments:
> ------------------------------------------------------------------------
>
> [2001-10-26 15:44:55] sander@php.net
>
> mysql uses a different character-set than your browser does. Therefor, it prints character 128
> (the euro-sign) different than most text-processors.
> It is actually stored correctly, if you retrieve it (with i.e. PHP) and display it in your
> browser, it still is a euro-sign.
>
> ------------------------------------------------------------------------
>
> [2001-10-26 11:15:08] Martin_Rauch@web.de
>
> Try this
>
> $headline = "This is a € prize";
> mysql_db_query( $db, "insert into article set headline='$headline'");
>
> this would insert the string "This is a € prize"!
>
> obviously the command mysql_db_query does a converting on the input string. But in this case
> the result would be
> a false string.
>
> Any help?
> Martin
>
> ------------------------------------------------------------------------
>
>
>
> Edit this bug report at http://bugs.php.net/?id=13839&edit=1
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net
> For additional commands, e-mail: php-dev-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Markus Fischer, http://guru.josefine.at/~mfischer/
EMail: mfischer@guru.josefine.at
PGP Public Key: http://guru.josefine.at/~mfischer/C2272BD0.asc
PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0
-All your scripts are belong to Zend-
Thread (5 messages)