View Single Post
  #1  
Old 10th November 2003, 12:30
nopadon's Avatar
nopadon nopadon is offline
Member
 
Join Date: Mar 2002
Location: Thailand
Posts: 54
nopadon is on a distinguished road
Baan: Infor ERP LN FP3 - DB: Oracle and SQL 2008 - OS: Windows 2008
how to change collation name on baandb database (SQL 2000 Server)

Dear Sir,

we have some problem one local character. baandb return local character to ?????? . so we cannot read it.
so we would like to change collation name to new.
but we not idea how to change it on SQL 2000 Server.

we have to try to rebuild master (rebuildm.exe) . but rebuildm will copy x86/data/ master.mdf , .... model.mdf.... but and rebuild all to new collation name. but baandb nerver change it. how to change collation baandb on SQL server.


holply anyone can help me.

Regards
Nopadon

Note. Oracle we change solve this problem by modify registry value Name is NLS_LANG and change Value data but SQL 2000 Server, as I know can do only change collation name.
Reply With Quote