adding amharic to SQL

I'm trying to build a database which will support amharic,
It is not defined in the SQL server collations,
How can I add amharic to be supported by the server ?
Amaharic is part of unicode 4.
If I add amharic to windows does it enough ?
Thanks,
Eyal
eyalbengal@.gmail.comeyalbengal@.gmail.com (eyalbengal@.gmail.com@.discussions.microsoft.com)
writes:
> I'm trying to build a database which will support amharic,
> It is not defined in the SQL server collations,
> How can I add amharic to be supported by the server ?
> Amaharic is part of unicode 4.
> If I add amharic to windows does it enough ?
Unfortunately, I don't think you have much luck here. You cannot add
collations to SQL Server.
You can of course store data in Amharic in nvarchar columns, but without
a good collation you cannot ger proper sorting, proper rules for comparing
etc. The best choice is probably a binary collation, for instance
Latin1_General_BIN, but it's a poor substitution.
I also looked of what is available in SQL 2005, but I can't see Ahmaric
or any related language there.
I would suggest that you drop a mail to sqlwish@.microsoft.com so they
know that there is a need for Amharic and related languages out there.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi,
Did you manage to solve the problem?
I am having the same problem, i cant get my database to sort properly.
Frans
"Erland Sommarskog" wrote:

> eyalbengal@.gmail.com (eyalbengal@.gmail.com@.discussions.microsoft.com)
> writes:
> Unfortunately, I don't think you have much luck here. You cannot add
> collations to SQL Server.
> You can of course store data in Amharic in nvarchar columns, but without
> a good collation you cannot ger proper sorting, proper rules for comparing
> etc. The best choice is probably a binary collation, for instance
> Latin1_General_BIN, but it's a poor substitution.
> I also looked of what is available in SQL 2005, but I can't see Ahmaric
> or any related language there.
> I would suggest that you drop a mail to sqlwish@.microsoft.com so they
> know that there is a need for Amharic and related languages out there.
>
> --
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>