Bug #9396 Currency symbol for GBP - £ - does not work

• Submitted: 25 Mar 2005 1:40
• Modified: 25 Mar 2005 6:12
• Reporter: Luke Burgess
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• CPU Architecture: Any

[25 Mar 2005 1:40] Luke Burgess

Description:
UK Price information in a mediumtext field does not work.

"Prices from £500-£2000" results in:

mysql> Prices from
mysql> #
mysql> #500-
mysql> #
mysql> 2000

This problem is serious because when mysqldump is used to backup a database, the system cannot import data back in again!!

How to repeat:
INSERT INTO tablename (fieldname) VALUES ('Prices from £500-£2000');

Suggested fix:
Allow £ to be used
Automatically escape £ when mysqldump is used
Don't convert £ into #
Allow £ to be escaped

Include in current documentation a workaround for this problem!!!!

£ = pound
# = hash

Why are the names for these symbols always confused?

[25 Mar 2005 6:12] Alexander Keremidarski

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

mysql> insert into t values('Prices from £500-£2000');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t;
+--------------------------+
| t                        |
+--------------------------+
| Prices from £500-£2000   |
+--------------------------+
1 row in set (0.00 sec)

[25 Mar 2005 11:45] Luke Burgess

mysql> create table t ( description mediumtext ) TYPE=MyISAM;
Query OK, 0 rows affected (0.07 sec)

mysql> #insert into t values('Prices from
mysql> #500-
mysql> 2000');
    '>

The second query has NOT worked for me. Upon typing £, a # is inserted at the beginning of line, and £ is replaced with a 2nd hash. Could you explain why this happens to me and not to you ?!

The second query - if it was accepted - should have looked like:

insert into t values('Prices from £500-£2000');