Weird Characters Revisited

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
JohnLug Members Profile Find Members Posts Groupie Joined: 16 June 2008 Status: Offline Points: 108	Post Options Post Reply Quote JohnLug Report Post Thanks(0) Quote Reply Topic: Weird Characters Revisited Posted: 26 October 2011 at 1:59am
	OK, again bringing up a problem with weird characters in posts. Check back and in version 9.X, didn't have this problem. Had a few different people check. Now one question... Could this have anything to so with the MS SQL server? Could a "language" setting be wrong? Now sure if I'm even asking the proper question, but this is driving my client crazy! Am I the only one experiencing this problem???

JohnLug Members Profile Find Members Posts Groupie Joined: 16 June 2008 Status: Offline Points: 108	Post Options Post Reply Quote JohnLug Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 2:03am
	And as an experiment, put some of the "problem" characters in MS Word and cut and pasted here, with NO scrambling!! Testing ‘quote’ “Dbl Quote” @ ampersand

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 8:33am
	Character encoding depends on a number of things:- 1. The Character Encoding you have set in the admin area of version 10. If you update this then any data needs to be reposted back to the server so that it is saved in the correct character set. This forum uses 'UTF-8' 2. The locale settings of the server that you are using. This forums server uses the UK locale. 3. The collation settings of your SQL Server Database. This forum uses 'Latin1_General_CI_AS' collation.
	Web Wiz Forums Hosting ASP.NET Web Hosting

JohnLug Members Profile Find Members Posts Groupie Joined: 16 June 2008 Status: Offline Points: 108	Post Options Post Reply Quote JohnLug Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 2:12pm
	Is there any way that I can run a script or anything to get the locale and collation settings on my server without asking my host?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 2:28pm
	Locale settings will usually be for what ever country your host is in. For example we are a UK web host and so have the locale set to UK for all our Share Hosting Servers. You can change the locale that your forum runs under by editing the common.asp file and setting the LCID according to the settings on the page below:- http://www.webwiz.net/kb/asp-tutorials/date-time-settings.htm You can see the collation of your database by using SQL Server Studio Manager to view the properties of your database.
	Web Wiz Forums Hosting ASP.NET Web Hosting

JohnLug Members Profile Find Members Posts Groupie Joined: 16 June 2008 Status: Offline Points: 108	Post Options Post Reply Quote JohnLug Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 3:51pm
	OK... I have an "older" test forum set up using version 9.68 Got to an old post that hasn't been touched other than viewed. The post looks correct. http://rjcomps.com/cp/forum_posts.asp?TID=768 (go down to "Cauda Equina Syndrome" Open the SAME POST in version 10.03 and the weird characters are there! http://chronicpainsite.com/mb/forum_posts.asp?TID=768

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 4:33pm
	There are lots of reasons that could cause this, although I can rule out the usual cause of page encoding as both are set to UTF-8. It could be that the modifications that you have done are causing the problem. The fact that the post is pasted from Word bloating it out with non standard code within the HTML doesn't help. It could also be the way the database has been handled, if you have used the import/export tools of SQL Server Studio Manager it may have corrupted the data and saved it in the woring format in the new database. It could be the collation of the database is different in the old database to the new. Like I said there are many things that can cause this and there are some many server, browser, and database settings that come in to play that it makes it very difficult to nail down the exact reason why you are seeing this.
	Web Wiz Forums Hosting ASP.NET Web Hosting

JohnLug Members Profile Find Members Posts Groupie Joined: 16 June 2008 Status: Offline Points: 108	Post Options Post Reply Quote JohnLug Report Post Thanks(0) Quote Reply Posted: 26 October 2011 at 5:20pm
	BOTH of these links are using the SAME database. And the C&P from Word worked ok with Version 9 The modifications are the same in both versions also.

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum