My team is trying to find a way to incorporate support for First Nation languages in some of our applications. The web based forms accept the information correctly but it would appear that once it's committed to the database, certain character are replaced with questions marks.
We are using SQL server 2022 with the default collations set to: SQL_Latin1_General_CP1_CI_AS.
I'm currently just trying to alter a single column for testing:
ALTER TABLE dbo.LangTest
ALTER COLUMN LangAfter VARCHAR(50) COLLATE Latin1_General_100_CI_AI_SC_UTF8Here are few examples of the characters it needs to support:
səlilwətaɬ ƛ̓éxətəm Tla-hut-um Tsleil-Waututh
1条答案
按热度按时间oewdyzsn1#
The primary database I was concerned with does use varchar. I created a test database and was experimenting with changing columns. When I switched to database collation and used nvarchar it worked. As mentioned in my comment, we use several different applications and databases and will be using a service specialist for our project now.