From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Sat Feb 12 2005 - 06:09:35 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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" <mysql2fishnet.co.uk> 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
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]