error

Question

how to fix Indic_general_90_ci_as

Answer 1

That's a collation, what do you what to fix here/where?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Could you please share your question against the collation ?

SELECT * FROM fn_helpcollations() where name = 'Indic_General_90_CI_AS' to read about the collation. 

Indic-General-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

You can use below script to find your objects and related collation ob DB level. .

SELECT object_name(object_id) as TableName, name as ColumnName, collation_name
FROM sys.columns
WHERE object_name(object_id) NOT LIKE 'sys%'
AND object_name(object_id) NOT LIKE 'queue%'
AND object_name(object_id) NOT LIKE 'file%'
AND object_name(object_id) NOT LIKE 'spt%'
AND object_name(object_id) NOT LIKE 'MSrep%'

Answer 3

Hi jatinmehra,

>how to fix Indic_general_90_ci_as

Follow steps in the doc. to set or change the collation: set-or-change-the-server-collation, set-or-change-the-database-collation

And this could be helpful: how-to-fix-the-collation-of-a-microsoft-sql-server-database

BR,

Mia

If the reply helped, please “Mark Answer” and upvote it.--Mia

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 4

Hi jatinmehra,

Is the reply helpful?

BR,

Mia

If the reply helped, please "Mark Answer" and upvote it.--Mia

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.