collation problem

I have a database that has Korean_Wansung_CI_AS as the default collation. I
need to use this database to interact with another database (e.g. merge
tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
first step is to change the default collation of the first databse from
Korean to Latin1. How do I do this?
Thanks, Dick
use ALTER DATABASE
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Dick Swager" <cswager.no.spam@.cox.net> wrote in message
news:e5PVqLpJGHA.964@.tk2msftngp13.phx.gbl...
> I have a database that has Korean_Wansung_CI_AS as the default collation.
I
> need to use this database to interact with another database (e.g. merge
> tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
> first step is to change the default collation of the first databse from
> Korean to Latin1. How do I do this?
> Thanks, Dick
>
|||Thanks. I still have a problem though because the 'alter database' fails.
The failure is probably because many of the tables were created using the
Korean collation and so there are many columns that are dependent on it.
Does that make sense?
I intend to try to alter the tables get get rid of such a dependency and try
again, but there are a lot of tables. I don't think there are any Korean
characters used int eh database though so I should be able to do it.
Dick
"Jack Vamvas" <DELETE_BEFORE_REPLY_jack@.ciquery.com> wrote in message
news:droai9$2ct$1@.nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> use ALTER DATABASE
> --
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "Dick Swager" <cswager.no.spam@.cox.net> wrote in message
> news:e5PVqLpJGHA.964@.tk2msftngp13.phx.gbl...
> I
>
|||I have the simillar problem. Please follow this thread.
http://groups.google.com/group/comp...643198997e7b3f
|||Thanks Sai. This looks like just the thing I need. It has been put on the
back burner though so I won't have the chance to report any results for a
while.
Dick
"Sai" <sbillanuka@.gmail.com> wrote in message
news:1138784646.094858.34330@.o13g2000cwo.googlegro ups.com...
>I have the simillar problem. Please follow this thread.
> http://groups.google.com/group/comp...643198997e7b3f
>

collation problem

I have a database that has Korean_Wansung_CI_AS as the default collation. I
need to use this database to interact with another database (e.g. merge
tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
first step is to change the default collation of the first databse from
Korean to Latin1. How do I do this?
Thanks, Dickuse ALTER DATABASE
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Dick Swager" <cswager.no.spam@.cox.net> wrote in message
news:e5PVqLpJGHA.964@.tk2msftngp13.phx.gbl...
> I have a database that has Korean_Wansung_CI_AS as the default collation.
I
> need to use this database to interact with another database (e.g. merge
> tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
> first step is to change the default collation of the first databse from
> Korean to Latin1. How do I do this?
> Thanks, Dick
>|||Thanks. I still have a problem though because the 'alter database' fails.
The failure is probably because many of the tables were created using the
Korean collation and so there are many columns that are dependent on it.
Does that make sense?
I intend to try to alter the tables get get rid of such a dependency and try
again, but there are a lot of tables. I don't think there are any Korean
characters used int eh database though so I should be able to do it.
Dick
"Jack Vamvas" <DELETE_BEFORE_REPLY_jack@.ciquery.com> wrote in message
news:droai9$2ct$1@.nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> use ALTER DATABASE
> --
> Jack Vamvas
> ________________________________________
__________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "Dick Swager" <cswager.no.spam@.cox.net> wrote in message
> news:e5PVqLpJGHA.964@.tk2msftngp13.phx.gbl...
> I
>|||I have the simillar problem. Please follow this thread.
6aac5b4737dc29/a4643198997e7b3f#a4643198997e7b3f" target="_blank">http://groups.google.com/group/comp...4643198997e7b3f|||Thanks Sai. This looks like just the thing I need. It has been put on the
back burner though so I won't have the chance to report any results for a
while.
Dick
"Sai" <sbillanuka@.gmail.com> wrote in message
news:1138784646.094858.34330@.o13g2000cwo.googlegroups.com...
>I have the simillar problem. Please follow this thread.
> 896aac5b4737dc29/a4643198997e7b3f#a4643198997e7b3f" target="_blank">http://groups.google.com/group/comp...4643198997e7b3f
>

collation problem

I have a database that has Korean_Wansung_CI_AS as the default collation. I
need to use this database to interact with another database (e.g. merge
tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
first step is to change the default collation of the first databse from
Korean to Latin1. How do I do this?
Thanks, Dickuse ALTER DATABASE
--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Dick Swager" <cswager.no.spam@.cox.net> wrote in message
news:e5PVqLpJGHA.964@.tk2msftngp13.phx.gbl...
> I have a database that has Korean_Wansung_CI_AS as the default collation.
I
> need to use this database to interact with another database (e.g. merge
> tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
> first step is to change the default collation of the first databse from
> Korean to Latin1. How do I do this?
> Thanks, Dick
>|||Thanks. I still have a problem though because the 'alter database' fails.
The failure is probably because many of the tables were created using the
Korean collation and so there are many columns that are dependent on it.
Does that make sense?
I intend to try to alter the tables get get rid of such a dependency and try
again, but there are a lot of tables. I don't think there are any Korean
characters used int eh database though so I should be able to do it.
Dick
"Jack Vamvas" <DELETE_BEFORE_REPLY_jack@.ciquery.com> wrote in message
news:droai9$2ct$1@.nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> use ALTER DATABASE
> --
> Jack Vamvas
> __________________________________________________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "Dick Swager" <cswager.no.spam@.cox.net> wrote in message
> news:e5PVqLpJGHA.964@.tk2msftngp13.phx.gbl...
>> I have a database that has Korean_Wansung_CI_AS as the default collation.
> I
>> need to use this database to interact with another database (e.g. merge
>> tables and views) that has SQL_Latin1_General_CP1_CI_AS collation. The
>> first step is to change the default collation of the first databse from
>> Korean to Latin1. How do I do this?
>> Thanks, Dick
>>
>|||I have the simillar problem. Please follow this thread.
http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/896aac5b4737dc29/a4643198997e7b3f#a4643198997e7b3f|||Thanks Sai. This looks like just the thing I need. It has been put on the
back burner though so I won't have the chance to report any results for a
while.
Dick
"Sai" <sbillanuka@.gmail.com> wrote in message
news:1138784646.094858.34330@.o13g2000cwo.googlegroups.com...
>I have the simillar problem. Please follow this thread.
> http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/896aac5b4737dc29/a4643198997e7b3f#a4643198997e7b3f
>