Hi Mike

here are the two column definitions:

Oracle:

NAME NOT NULL VARCHAR2(255 CHAR)

SQL Server

NAME VARCHAR (255) NOT NULL

Oracle treats them as unique as...

Hi Folks

if anyone can explain the last question to me, i would appreciate it

Thanks

Jim

Hi Folks

I changed the Case Sensitivity for the table column

Now I have an issue with what looks like trailing spaces in the name value

So a name value of "P00204"...

Thanks WayneS

was out on Friday so i will try it today

Jim

Hi Folks

Can some one tell me the correct syntax for changing the COLLATION to SQL_Latin1_General_Cp1_CS_AS for a column called Name in a table called DTREE

I cannot figure out the...

Hi David

well..what a bummer

i only tried it at the database level, not table level

guess i will change it back as i do not want to worry about objects having sensitivity

Thanks

Jim

Hi WayneS

I guess I found that out, but why ?

Why would you make the object(s) case sensitive at all ?

I just want the data to be case sensitive

are you...

Hi Folks

I made the change to the database after dropping all tables as it would not allow me change the COLLATE value until I did so

a follow-up question and why

it...

I am running the tests on windows server 2008 with sql server 2008

Jim

Thanks norie

will take a look

Jim

Hi luckus_g

it is not an issue to change it

i am in just testing creating tables and indexes and importing data right now

so i can start over after i make the...

HI David

thanks

i will look into these documents

Jim

Hi David

well..looking up these collation codes (which you need a PHD to review them all)

I have

SQL_Latin1_General_CP1_CI_AS

but i do not see what it should be chaged to in reviewing

http://msdn.microsoft.com/en-us/library/ms143508(v=SQL.100).aspx

any...

Thanks Derrick

I will give it a shot

Jim

Thanks Very Much Lowell

I wil check it out

Jim