Error when using × in My Aquaria

[KittyKat]

I get the following error when trying to use the multiplication sign (×) in any of the text fields.

General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\x97 300W...' for column 'heating' at row 1 [1366]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: webmaster@planetcatfish.com

[Jools]

Thanks, that detail makes it a lot easier to fix. Will look into it.

Jools

[MatsP]

@Jools: I think this just needs the same utf8-to-html treatment that we have in some other places.

I will check in on this subject on Saturday, and if Jools hasn't said it is/will be fixed, I will try to fix it - it should be relatively easy.


--
Mats

[MatsP]

I can reproduce this problem, but the easy fix I thought I could make doesn't seem to work.

I will keep on digging. I'm pretty sure I know what the basic problem is, I just don't understand why the fix doesn't work.

--
Mats

[MatsP]

Ok, managed to track down where some of the stuff got "messed about", causing my fix to not work. Also had to make some changes to the htmlentities() function calls, as it would interfere with the way utf8_to_html() encoded content. As always, the updated code will be available when Jools has checked it over and uploaded it to the real site (just in case you were tempted to try it out right now).

@Jools: In R1351.

--
Mats

[Jools]

This is now online. Fixed?

Jools

[KittyKat]

Yep, works great! Thanks for fixing