Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Collation on tblAuthor::User_Code?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Collation on tblAuthor::User_Code?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
RobertCook View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RobertCook Quote  Post ReplyReply Direct Link To This Post Topic: Collation on tblAuthor::User_Code?
    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
Back to Top
india View Drop Down
Senior Member
Senior Member


Joined: 21 November 2003
Status: Offline
Points: 499 		Post Options Post Options   Thanks (0) Thanks(0)   Quote india Quote  Post ReplyReply Direct Link To This Post Posted: 05 January 2004 at 9:15am
SEARCH
Back to Top
neotrix View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 09 November 2003
Location: Pakistan
Status: Offline
Points: 433 		Post Options Post Options   Thanks (0) Thanks(0)   Quote neotrix Quote  Post ReplyReply Direct Link To This Post 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 ?
Say to the believing men..
Back to Top
maddkat View Drop Down
Groupie
Groupie


Joined: 13 December 2003
Status: Offline
Points: 154 		Post Options Post Options   Thanks (0) Thanks(0)   Quote maddkat Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
RobertCook View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RobertCook Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
RobertCook View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RobertCook Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392 		Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post 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 .....
Cheers
TheKiwi
Internet Infobahn - website design and hosting
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 05 January 2004 at 7:10pm
wwf does not set a collation so it is whatever your default collation is.
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.