Introduce Hebrew collation to a shelf application

Here are 2 questions:
1. Can I install MSDE2000 with Hebrew collation (Hebrew_CI_AI) and how exactly it is done
2. Can I assume that a new application which creates it's database on the MSDE2000 take the Hebrew collation by inheritance
Thanks
Moshe
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...eaa9bc9c4d8d44
*****************************************
1. Yes. You would pass COLLATION="Hebrew_CI_AI" on the MSDE setup command
line. See
http://msdn.microsoft.com/library/de...us/distsql/dis
tsql_84xl.asp for details.
2. It depends on the application. If (a) the app's setup routine creates
its own database by running scripts instead of attaching an already
existing database, and (b) if the scripts don't hard-code a collation in
the CREATE TABLE statements, then yes, the app's database will use the
instance-level collation. But if the app's setup scripts hard-code a
particular collation, the hard-coded collation will be used for the newly
created tables. If the app simply attaches an pre-created database, the
instance-level collation won't apply, either.
Bart
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "moshe shenker via SQLMonster.com" <forum@.SQLMonster.com>
| Subject: Introduce Hebrew collation to a shelf application
| Date: Thu, 04 Nov 2004 10:19:00 GMT
| Message-ID: <a56e46f74adc433ca5eaa9bc9c4d8d44@.SQLMonster.com >
| Organization: http://www.SQLMonster.com
| Newsgroups: microsoft.public.sqlserver.msde
| NNTP-Posting-Host: 178.67-18-207.reverse.theplanet.com 67.18.207.178
| Lines: 1
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP10
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.msde:17520
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Here are 2 questions:
| 1. Can I install MSDE2000 with Hebrew collation (Hebrew_CI_AI) and how
exactly it is done
| 2. Can I assume that a new application which creates it's database on the
MSDE2000 take the Hebrew collation by inheritance
| Thanks
| Moshe
|
| *****************************************
| * This message was posted via http://www.sqlmonster.com
| *
| * Report spam or abuse by clicking the following URL:
| *
http://www.sqlmonster.com/Uwe/Abuse...5eaa9bc9c4d8d4
4
| *****************************************
|