| Author |
 Topic  |
|
|
benildusmuerling
Yak Posting Veteran
Australia
81 Posts |
 Posted - 04/19/2012 : 19:51:38
|
Hi All,
in my server under system databases my master database collation says as - Latin1_General_CI_AS and my working database says as - SQL_Latin1_General_CP1_CI_AS, how could I bring this to consistency by bringing my working database as Latin1_General_CI_AS.
My application frontt end does not work due to this.
Thanks,
Ben |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48029 Posts |
|
|
benildusmuerling
Yak Posting Veteran
Australia
81 Posts |
Posted - 04/22/2012 : 20:22:19
|
Hi Vikash / All,
Would anyone be in a position to say, am I to proceed with it, I do not get what does it meant by you, to consider the stuffs before proceeding, well and truly am gonna have a backup of the database before hand, is there anything else that I should be eyeing on before changing the collation.
Thanks,
Antonio Benildus (AB) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48029 Posts |
Posted - 04/22/2012 : 21:34:13
|
if you're backuping database thats definitely good.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
benildusmuerling
Yak Posting Veteran
Australia
81 Posts |
Posted - 04/22/2012 : 22:07:43
|
Hi Visakh,
can you please tell whether I could proceed as below.
ALTER DATABASE testDB
COLLATE Latin1_General_CI_AS;
GO
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48029 Posts |
Posted - 04/22/2012 : 22:11:43
|
yep...but keep in mind that this gets applied only to new columns added to database.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
benildusmuerling
Yak Posting Veteran
Australia
81 Posts |
Posted - 04/25/2012 : 22:57:45
|
Hi vikash,
is there a 100 percent guarantee, that I would be able to amend old records, which has been held back, as a result of altering the database with the new collation.
Thanks,
AB |
|
|
|
benildusmuerling
Yak Posting Veteran
Australia
81 Posts |
Posted - 05/10/2012 : 23:29:17
|
Thanks a million in reading this post
Is there anyone please, to help me with the collation issue that am having, it indeed would be a great help, I am holding so many things and my backlog grows, please can you help me in sorting this..
issue is the system database which is the master database has a different collation that the working database, which prevents from working together, and am not in a position to work with the application to insert records, via the front end application, so as I am unable in updating records as well..
I have tried, doing altering the database setting up the single mode and still it does not work - this is for your information
Thanks,
AB |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48029 Posts |
Posted - 05/10/2012 : 23:36:04
|
quote:
Originally posted by benildusmuerling
Hi vikash,
is there a 100 percent guarantee, that I would be able to amend old records, which has been held back, as a result of altering the database with the new collation.
Thanks,
AB
you will still be able to amend the old columns but it will still be in old collation unless you alter it explicitly by means of ALTER TABLE statement
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
benildusmuerling
Yak Posting Veteran
Australia
81 Posts |
Posted - 05/10/2012 : 23:50:07
|
Hi Vikash and all,
Thanks Vikash yet again, in helping me, and to other viewers seeing ma post
amending the database with the altering query does not work, even with the setting mode on with the single user, I want further suggestions like you know
maybe import the data into an excel sheet as per to the number of tables and then, export it back into the database back again, with the use of SSIS package
does than make sense..
cuase I am sick of hitting the alter database query now, as it does not work in by any of the way.
Thanks,
AB |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48029 Posts |
Posted - 05/11/2012 : 00:07:25
|
why it doesnt work? did you get some error?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
Collation in SQL Server
