Page 1 of 1

Extended chars not allowed in some fields

PostPosted: Thu Apr 10, 2008 7:45 pm
by sarabob
Name, type and 'who created it' don't allow extended characters (eg é) - the fields go red.

Re: Extended chars not allowed in some fields

PostPosted: Fri Apr 11, 2008 3:57 pm
by Darkflame
ahh..easily fixed, I had the compilers encoding set wrong.
Next time I update the edit review page (say, to fix a few spelling errors) this should be fixed too.

Re: Extended chars not allowed in some fields

PostPosted: Sun Apr 13, 2008 7:46 pm
by sarabob
Darkflame wrote:ahh..easily fixed, I had the compilers encoding set wrong.
Next time I update the edit review page (say, to fix a few spelling errors) this should be fixed too.


Still getting errors on 'Who created it' field.

on page http://www.darkflame.co.uk/Rateoholic_b ... d=365#blah there is a link to 'search for Sabriél" at the top (including the random ending double quote). Clicking on this takes me to a 'no results found' page, with sabri%c3%a9l in the search box.

I love iso-8859-1/utf-8 problems, me.

Edit: I swear you fix problems as I type them. Did the 'search for "Sabriél" just gain its leading double-quote, or is it me?

Re: Extended chars not allowed in some fields

PostPosted: Sun Apr 13, 2008 9:17 pm
by Darkflame
not me guv, I fixed some quote errors with things today, but not the character set issue.

I notice the name of your review is stored in the database as "Sabriél", which works when searched for.
The problem hopefully is just a mis-match in text format versions between the javascripts.
Everything is now UTF-8 now in my source, but it might take a few days till all those versions are compiled and updated online. (as I'm fixing many things at once).
Hopefully if I'm very lucky, thats all it is.
If not, I'll be back in a few days experimenting.

Re: Extended chars not allowed in some fields

PostPosted: Mon Apr 14, 2008 8:22 pm
by Darkflame
Sabriél should be working now :)

Just had to be a
Code: Select all
SET NAMES 'utf8';


In before my MySQL lookups.