how to set collation

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
snooper Members Profile Find Members Posts Mod Builder Group Joined: 23 April 2002 Location: Israel Status: Offline Points: 333	Post Options Post Reply Quote snooper Report Post Thanks(0) Quote Reply Topic: how to set collation Posted: 13 October 2004 at 1:18pm
	for the SQL version, i have found that some of the fields might have to be set to another collation that the defaul (latin). my question is how can i set it to a different collation (i know the one i need) in the Mssql_server_setup.asp file? thanks! PS: i have also found that "text" fields must be changed to "ntext"

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 13 October 2004 at 7:56pm
	in order to change the collation manually you would have to edit each create script. I would just run a default setup to a test database, script the database out with Enterprise Manager and then do a global text replace from latin collation to hebrew. Hope that helps.
	Blog \| MPG Tracker

Post Reply

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.