Web Wiz Forums - how to set collation

Print Page | Close Window

how to set collation

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12159
Printed Date: 09 April 2026 at 8:32am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: how to set collation

Posted By: snooper
Subject: how to set collation
Date 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"

Replies:

Posted By: michael
Date 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.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker