Re: How to change the server language?

2008-11-02 Thread Mark Milke
 BTW what version of SQL?

microsoft slq server 8.00.760

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: How to change the server language?

2008-11-01 Thread Mark Milke
Hi BMax,

 generally it depends on SQL Server Collation, particularry on ARsystem DB
 collation.

Sure.

@ALL
On UNIX one can change the character coding in the startup script. How
to change that on Windows?


Mark

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: How to change the server language?

2008-11-01 Thread BMax
Unfortunately you cannot change SQL Database collation on  the fly.  You
can change SQL Server collation, but it will only has effect when you will
create new databases.  

I guess you have options:
1. Create new DB with collation you do need. Redo your ARS installation.
2. Transfer a database from one collation to another collation. Pls see MS
KB article about this:
http://support.microsoft.com/kb/325335

BTW what version of SQL?


Mark Milke wrote:
 
 Hi BMax,
 
 generally it depends on SQL Server Collation, particularry on ARsystem DB
 collation.
 
 Sure.
 
 @ALL
 On UNIX one can change the character coding in the startup script. How
 to change that on Windows?
 
 
 Mark
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 

-- 
View this message in context: 
http://www.nabble.com/How-to-change-the-server-language--tp20257466p20278995.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: How to change the server language?

2008-10-31 Thread BMax
Mark,

generally it depends on SQL Server Collation, particularry on ARsystem DB
collation.



Mark Milke wrote:
 
 Hi Listers,
 
 my server (7.1 on my slq server 8.00.760) shows ENU;1250 as server
 language. How to change that setting? I want my ars to be able to
 store polish characters. I changed the setting user locale in the user
 preferences, but this doesn't help.
 
 
 Mark
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 

-- 
View this message in context: 
http://www.nabble.com/How-to-change-the-server-language--tp20257466p20276350.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


How to change the server language?

2008-10-30 Thread Mark Milke
Hi Listers,

my server (7.1 on my slq server 8.00.760) shows ENU;1250 as server
language. How to change that setting? I want my ars to be able to
store polish characters. I changed the setting user locale in the user
preferences, but this doesn't help.


Mark

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are