Web Wiz Support and Community Forums : Collation on tblAuthor::User_Code? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 07:57:50 +0000 Mon, 05 Jan 2004 19:10:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8576 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Collation on tblAuthor::User_Code? : wwf does not set a collation so...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44697.html#44697 Author: michael
Subject: 8576
Posted: 05 January 2004 at 7:10pm

wwf does not set a collation so it is whatever your default collation is.]]> Mon, 05 Jan 2004 19:10:23 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44697.html#44697 <![CDATA[Collation on tblAuthor::User_Code? : RobertCook wrote: Could anyone...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44628.html#44628 Author: thekiwi
Subject: 8576
Posted: 05 January 2004 at 1:02pm

Originally posted by RobertCook RobertCook wrote:


Could anyone tell me the collation for User_Code so that I can adjust the collation in my table accordingly?

Thanks in advance.

WHats the current default collation for your SQL Server?

Mine was Case Sensitive and I ended up rebulding my whole SQL Server to overcome your sort of problem .....

]]> Mon, 05 Jan 2004 13:02:54 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44628.html#44628 <![CDATA[Collation on tblAuthor::User_Code? : neotrix wrote:I dont understand...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44623.html#44623 Author: RobertCook
Subject: 8576
Posted: 05 January 2004 at 12:37pm

Originally posted by neotrix neotrix wrote:

I dont understand your problem ? you want multiple items of your site to require a log in, the same log in that the forum requires ? right ? is that what you are saying ?

Yeah, but that's besides the point.
What I want is simply to know the collation used for the column User_Code in the table tblAuthor.

]]> Mon, 05 Jan 2004 12:37:45 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44623.html#44623 <![CDATA[Collation on tblAuthor::User_Code? : india wrote:SEARCH I did,...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44622.html#44622 Author: RobertCook
Subject: 8576
Posted: 05 January 2004 at 12:30pm

Originally posted by india india wrote:

SEARCH

I did, I searched on "collate" and "collation" but no results were returned for either...

]]> Mon, 05 Jan 2004 12:30:49 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44622.html#44622 <![CDATA[Collation on tblAuthor::User_Code? : I tihnk there is a simple include...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44614.html#44614 Author: maddkat
Subject: 8576
Posted: 05 January 2004 at 11:40am

I tihnk there is a simple  include file floating around here all ready
try searching the Mod forum]]> Mon, 05 Jan 2004 11:40:08 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44614.html#44614 <![CDATA[Collation on tblAuthor::User_Code? : I dont understand your problem...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44597.html#44597 Author: neotrix
Subject: 8576
Posted: 05 January 2004 at 11:02am

I dont understand your problem ?

you want multiple items of your site to require a log in, the same log in that the forum requires ? right ?

is that what you are saying ?

]]> Mon, 05 Jan 2004 11:02:47 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44597.html#44597 <![CDATA[Collation on tblAuthor::User_Code? : SEARCH ]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44588.html#44588 Author: india
Subject: 8576
Posted: 05 January 2004 at 9:15am

SEARCH]]> Mon, 05 Jan 2004 09:15:13 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44588.html#44588 <![CDATA[Collation on tblAuthor::User_Code? : Hi,I want to link several aspects...]]> https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44587.html#44587 Author: RobertCook
Subject: 8576
Posted: 05 January 2004 at 9:13am

Hi,
I want to link several aspects of my site that require a login to the login for the forum, so that users only have to log in once to use all the features.
I'm using the User_Code column for this as this is stored in the cookie. But when I do a normal equal operation it comes up with a collation error. I fixed this by converting the collation for both columns (User_Code from the forum and from my table), but this seems to slow down the query dramatically.
Could anyone tell me the collation for User_Code so that I can adjust the collation in my table accordingly?

Thanks in advance.



Edited by RobertCook]]> Mon, 05 Jan 2004 09:13:18 +0000 https://forums.webwiz.net/collation-on-tblauthoruser-code_topic8576_post44587.html#44587