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, [EMAIL PROTECTED] wrote : > ID: 13839 > User updated by: [EMAIL PROTECTED] > Reported By: [EMAIL PROTECTED] > 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: "&#8364;" > > -> 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] [EMAIL PROTECTED] > > 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] [EMAIL PROTECTED] > > 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 &#8364; 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Markus Fischer, http://guru.josefine.at/~mfischer/ EMail: [EMAIL PROTECTED] 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- -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
