Hello.
Please tell us, what output the following statement produces: SHOW VARIABLES LIKE '%char%'; You can use hexademical values for inserting the data. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html "Ian Gibbons" <[EMAIL PROTECTED]> wrote: > Hi List, > > I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( of= > fical > mysql rpms). The data was originally stored in MySQL 3.something and was = > placed > into the database via a MySQLDump file. It is too late to reload the data= > . > > I have a table called fees: > > CREATE TABLE `fees` ( > `refID` int(11) NOT NULL default '0', > `price` text, > `tuitionFee` tinyint(4) default NULL, > `examFee` tinyint(4) default NULL, > `otherFee` tinyint(4) default NULL, > `feeText` text, > `pending` tinyint(4) default '0', > PRIMARY KEY (`refID`), > KEY `refID` (`refID`) > ) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin2 > > When I try updating the price field for one record, it doesn't seem to rec= > ognise the > pound sign (=A3): > > mysql> UPDATE fees SET price=3D '=A345' WHERE refID=3D732; > Query OK, 0 rows affected (0.00 sec) > Rows matched: 1 Changed: 0 Warnings: 0 > > mysql> select price from fees where refID=3D732; > +-------+ > | price | > +-------+ > | ?45 | > +-------+ > 1 row in set (0.00 sec) > > The same result ?45 is returned via php as well, so its not a console disp= > lay > problem. > > I have also tried this with the latin1 character set with the same results= > . > > I know I am probably better off changing the field type to a double and pl= > acing the > pound sign in my php code, but I am curious as to why this happens. > > Is it a problem with the character sets? Should I be using a different ch= > aracter set > for English language text ( no international chars ). > > Any help will be appreciated. > > Ian -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]