Hello EB
Can MSDE accept Hebrew characters and sort on them

*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=44ee3ed3207b48d38056ff3a7c5eab27

hi Moshe,
"moshe shenker via SQLMonster.com" <forum@SQLMonster.com> ha scritto
nel messaggio news:44ee3ed3207b48d38056ff3a7c5eab27@SQLMonster.com
[quoted text, click to view]

the supported collation for Hebrew chars are, as listed by fn_helpcollations
function:

SELECT * FROM ::fn_helpcollations()
WHERE NAME LIKE 'HEB%'
--<------
Hebrew_BIN
Hebrew, binary sort
Hebrew_CI_AI
Hebrew, case-insensitive, accent-insensitive, kanatype-insensitive,
width-insensitive
Hebrew_CI_AI_WS
Hebrew, case-insensitive, accent-insensitive, kanatype-insensitive,
width-sensitive
Hebrew_CI_AI_KS
Hebrew, case-insensitive, accent-insensitive, kanatype-sensitive,
width-insensitive
Hebrew_CI_AI_KS_WS
Hebrew, case-insensitive, accent-insensitive, kanatype-sensitive,
width-sensitive
Hebrew_CI_AS
Hebrew, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
Hebrew_CI_AS_WS
Hebrew, case-insensitive, accent-sensitive, kanatype-insensitive,
width-sensitive
Hebrew_CI_AS_KS
Hebrew, case-insensitive, accent-sensitive, kanatype-sensitive,
width-insensitive
Hebrew_CI_AS_KS_WS
Hebrew, case-insensitive, accent-sensitive, kanatype-sensitive,
width-sensitive
Hebrew_CS_AI
Hebrew, case-sensitive, accent-insensitive, kanatype-insensitive,
width-insensitive
Hebrew_CS_AI_WS
Hebrew, case-sensitive, accent-insensitive, kanatype-insensitive,
width-sensitive
Hebrew_CS_AI_KS
Hebrew, case-sensitive, accent-insensitive, kanatype-sensitive,
width-insensitive
Hebrew_CS_AI_KS_WS
Hebrew, case-sensitive, accent-insensitive, kanatype-sensitive,
width-sensitive
Hebrew_CS_AS
Hebrew, case-sensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
Hebrew_CS_AS_WS
Hebrew, case-sensitive, accent-sensitive, kanatype-insensitive,
width-sensitive
Hebrew_CS_AS_KS
Hebrew, case-sensitive, accent-sensitive, kanatype-sensitive,
width-insensitive
Hebrew_CS_AS_KS_WS

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea

You don't imagine how your answer is important to me, So, many thanks
Can you please advise on how exactly to change the MSDE2000 collation to Hebrew_CI_AI after it is installed

Regards
Moshe

*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-msde/669
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=83b1a2a3bbc64fdf96c70fa7fd312394

hi Moshe,
"moshe shenker via SQLMonster.com" <forum@SQLMonster.com> ha scritto
nel messaggio news:83b1a2a3bbc64fdf96c70fa7fd312394@SQLMonster.com
[quoted text, click to view]

you actually can't, for system databases, after install time... you have to
provide the desired collation as a paramenter at install time...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp
provides info for all possible parameters...
so you should specify the parameter
COLLATION="collation_name"
to your
c:\...\>setup.exe ..... /L*v "c:\MsdeLog.txt"
call

for user's database, you can define your collation at database level when
creating each database, see the COLLATE collation_name specification in the
CREATE DATABASE syntax
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp
...
more, as you already know, SQL Server 2000 allows you to define collations
at column level (please see CREATE TABLE synopsis at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_8g9x.asp)

and as regard the other questions, yes, you can provide the "Hebrew_CI_AI"
(case insensitive, accent insensitive) collations to the setup.exe bootstrap
installer of MSDE... this will set the system databases collation to that
setting and, as each useer database is created inheriting "model" database
settings, their collation will default to that setting..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply