14,494 questions
You can also refer to this official document.
Best regards,
Percy Tang
Error with Special Characters - Microsoft SQL Server Management Studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lucas Carminati
20
Reputation points
I have a database that when I open it, some data with accents appear with an error, an icon with a question mark appears. I tried to find solutions on the internet but I didn't find anything. I need to fix this problem and show the accent correctly without changing the database, without removing the accent.
I attached a database image with the error:
SQL Server Other
{count} votes
-
Lucas Carminati 20 Reputation points
2023-06-14T03:03:13.04+00:00 I'm using a database in Portuguese - Brazil. I've already tried to do a Cast like this: "SELECT CAST(Title AS varchar(100)) COLLATE Latin1_General_CI_AS as Title" but it removes the error icon and replaces it with a question mark. Can I solve this problem with code or do I have to do something in the extraction?
-
Viorel 122.5K Reputation points2023-06-14T07:38:50.2133333+00:00 Show an example of a correct word, that appears incorrectly. Maybe the Portuguese alphabet does not need the unicode type. And make sure that the data are valid.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-06-16T08:44:13.2533333+00:00 We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
-
Anonymous
2023-06-23T07:03:55.37+00:00 We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
Accepted answer
2 additional answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points2023-06-14T05:16:27.62+00:00 a question mark appears.
That happens if you have Unicode text, with can't presented as ASCII with oyur used collation (code page), for
example.
SELECT N'ภาษาไทย', 'ภาษาไทย'The second column shows ???.
So your database don't match your requirements to store Unicode. Change data type for varchar (ANSI) to Nvarchar = Unicode; a lot of work.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-06-14T22:03:28.55+00:00 The character you see is known as REPLACEMENT CHARACTER. Typically you see it when UTF-8 is expected, but the character is not part of a legal UTF-8 sequence.
To get the character correct, you may need to do something like:
SELECT cast(cast(col AS varbinary(100)) AS varchar(100) COLLATE Latin1_General_100_CI_AS)) FROM tblBut the hour is late here, and I don't have time to test.