Amharic

0 views

Skip to first unread message

Lajuana Paling

unread,

Aug 3, 2024, 3:33:13 PM8/3/24

to hercompdispli

I am using SQL Server 2014. I want to use amharic language in my database. The default collation for the database was Latin1_General_CP1_CI_AS. I changed it to Latin1_General_CI_AS. Both doesn't diplay amharic characters. They show the characters when typing but when comitted they are changed to question marks.

Try to use UNICODE data types such as NCHAR and NVARCHAR and you'll see your saved characters.Collation is only needed for sorting and comparing. Look through the list of collations and choose the most appropriate one.

Originally, you did not tell you are using Full-text search. That requires you to use key word LANGUAGE with name of your language. However, there are only 53 supported languages (see in sys.fulltext_languages) and amharic isn't there.

In Control Panel, find the Windows system locale name on the Advanced tab in Regional and Language Options. In Windows Vista, use the Formats" tab. The following table shows the corresponding collation designator to match collation settings with an existing Windows locale:

SQL Server allows to define a default collation on database level too. But this can lead into deep troubles, if you work with CREATE TABLE #table and use WHERE,ORDER BY,GROUP BY or JOIN (any comparison...) using character fields...

It is a different issue how the output of a query is displayed. This is an issue of the output window (or any other program you are using to display the values of your queries...). In this case it might be necessary to use the appropriate encoding and character set. This depends on the tools you are working with...