Re: sql2k Collation problems.

Hello,

You can explicitly specify the collation of the temporary table as
followings:

create table #temptb (cola varchar(10) collate Latin1_General_CI_AS )

You can also use the database_default option in the COLLATE clause to
specify that a column in a temporary table use the collation default of the
current user database for the connection instead of tempdb.

Specifying Collations
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da_3zw3.asp

For example, run the following code:

use mycoll
go
create table #temptb (cola varchar(10) collate database_default )
use tempdb
go
sp_help #temptb
go

Collation=Latin1_General_CI_AS

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: SQL7: case sensitivity
    ... In SQL Server 7 you specify the collation on the SERVER level (this is ... changed in SQL Server 2000 where you can specify it down to column level). ... which is supposed to store filenames stored on a Unix ...
    (microsoft.public.sqlserver.programming)
  • Re: Are SQL logins case sensitive
    ... > I tried BOL, but it does not specify case sensitive.? ... If you selected a case sensitive collation or a binary collation, ... >> Satish Balusa ...
    (microsoft.public.sqlserver.security)
  • RE: sql2k Collation problems.
    ... and variables are assigned the default collation of the database* ... you can specify a default collation for each new database you ... "Change the collation of the master database in SQL Server 2000" section. ...
    (microsoft.public.sqlserver.setup)
  • Collation --- please help!
    ... scripts to customers wrt collation issues. ... which is the default for UK SQL ... The only reason they do specify ...
    (microsoft.public.sqlserver.programming)
  • Re: SELECT . . . ORDER BY - SQL 2000 vs. JET 4
    ... Now I have to remove all of my bubble sort code (all 17 ... > will respect the collation and can be used to optimize your queries. ... > also change the default collation for an entire database, ... > You can also specify the collation for an entire instance of SQL Server, ...
    (microsoft.public.sqlserver.programming)