 character
Boss St Bloke Wednesday 24 November 2010 7.43pm
Hi James
Since you moved to your new server, you have the dreaded character problem occurring on some pages.
Have a look at my review "Expensive beer" on this page...
http://www.london-se1.co.uk/restaurants/reviews/238/the-draft-house
notice the "I gave her a crisp £20 note"
If you are using SQL server - this could be a collation setting or it could be a encoding setting in IIS.
Since you moved to your new server, you have the dreaded character problem occurring on some pages.
Have a look at my review "Expensive beer" on this page...
http://www.london-se1.co.uk/restaurants/reviews/238/the-draft-house
notice the "I gave her a crisp £20 note"
If you are using SQL server - this could be a collation setting or it could be a encoding setting in IIS.
James Hatts Sunday 28 November 2010 4.28pm
Hi BSB
Yes, this is annoying - it's to do with how the data was imported, rather than the settings of the database as it is now - so any newly entered data is fine.
At the moment I'm manually fixing a batch each day, which is laborious but means I can also pick up other formatting glitches along the way.
I'm sure there's a more efficient way of doing a bulk find and replace but I haven't had time to work that out yet.
Yes, this is annoying - it's to do with how the data was imported, rather than the settings of the database as it is now - so any newly entered data is fine.
At the moment I'm manually fixing a batch each day, which is laborious but means I can also pick up other formatting glitches along the way.
I'm sure there's a more efficient way of doing a bulk find and replace but I haven't had time to work that out yet.
Editor of the London SE1 website and SE1 Direct newsletter
To post a message, you must be a registered user. If you are already registered, please log in.