Web Wiz Support and Community Forums : how to set collation https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 06:47:15 +0000 Wed, 13 Oct 2004 19:56:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12159 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[how to set collation : in order to change the collation...]]> https://forums.webwiz.net/how-to-set-collation_topic12159_post67460.html#67460 Author: michael
Subject: 12159
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.]]> Wed, 13 Oct 2004 19:56:52 +0000 https://forums.webwiz.net/how-to-set-collation_topic12159_post67460.html#67460 <![CDATA[how to set collation : for the SQL version, i have found...]]> https://forums.webwiz.net/how-to-set-collation_topic12159_post67445.html#67445 Author: snooper
Subject: 12159
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"

 

]]> Wed, 13 Oct 2004 13:18:11 +0000 https://forums.webwiz.net/how-to-set-collation_topic12159_post67445.html#67445