Search problem

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
aladin11 Members Profile Find Members Posts Groupie Joined: 10 October 2009 Status: Offline Points: 70	Post Options Post Reply Quote aladin11 Report Post Thanks(0) Quote Reply Posted: 30 March 2010 at 12:51pm
	Hello, I have the same problem. Converted to SQL from Access using Upsize Wizard, now username with no-latin charactars can not login. Checking the table in SQL, I see that username is nvarchar (30). Should I change to ntext? (The message field in tblThread is ntext and displayed fine on the forum.) I also try to add "N" as yanbdr mentioned, but don't know where to start. Edited by aladin11 - 30 March 2010 at 1:07pm

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: 30 March 2010 at 4:05pm
	Don't change it to ntext as this will make your database work harder than it needs to. If you are going to try and change it change it from nvarchar to varchar You should also try changing the page encoding in the includes/setup_options_inc.asp before changing the database data type as it may just be an encoding issue with the wrong encoding being submitted to the server.
	Web Wiz Forums Hosting ASP.NET Web Hosting

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

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.