Web Wiz Forums - Collation on tblAuthor::User

Print Page | Close Window

Collation on tblAuthor::User_Code?

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=8576
Printed Date: 07 April 2026 at 7:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Collation on tblAuthor::User_Code?

Posted By: RobertCook
Subject: Collation on tblAuthor::User_Code?
Date 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.

-------------
Robert Cook
Webmaster of http://www.piratehideout.com - the Pirate Hideout

Replies:

Posted By: india
Date Posted: 05 January 2004 at 9:15am

Posted By: neotrix
Date 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 ?

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..

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

-------------
1+1-1=1

Posted By: RobertCook
Date Posted: 05 January 2004 at 12:30pm

india wrote:

SEARCH

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

-------------
Robert Cook
Webmaster of http://www.piratehideout.com - the Pirate Hideout

Posted By: RobertCook
Date Posted: 05 January 2004 at 12:37pm

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.

-------------
Robert Cook
Webmaster of http://www.piratehideout.com - the Pirate Hideout

Posted By: thekiwi
Date Posted: 05 January 2004 at 1:02pm

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 .....

-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting

Posted By: michael
Date Posted: 05 January 2004 at 7:10pm

wwf does not set a collation so it is whatever your default collation is.

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