The characters of a database's table's volumn_name is replaced by question marks, how to fix it ?

Question

Hi everyone, my database have a table which volumn_names are Chinese characters. when I use " SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'table-name '; " the volumn_name display correctly, but if I use " select volumn_name from table-name ", the content display correctly ,but the volumn_name it'self disply is ??. how to fix this problem ?

Answer 1

Hi @Tina Yi

What is your default collation designations? See: Server-level collations

If you need Chinese column names, try something like this:

CREATE TABLE ChineseTable 
(
 ID INT PRIMARY KEY,
 volumn_name NVARCHAR(100) COLLATE Chinese_PRC_CI_AS 
);

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Thank you CosmogHong-MSFT,but it not work.

My default collation designations is Chinese_PRC_CI_AS

it's the column_name itself can't display correctly, not the content.

Answer 3

Hi @Tina Yi

Since I cannot reproduce this issue, here are some additional suggestions you might refer to.

• Ensure that SSMS is configured to use a font that supports Chinese characters. You can adjust the font settings in SSMS by going to "Tools" > "Options" > "Environment" > "Fonts and Colors". Select a font that includes Chinese characters, such as "Microsoft YaHei" or "SimSun".
• Upgrade the SSMS to the newest version.
• Make sure that SSMS is configured to display characters using the correct encoding. You can check the encoding settings in SSMS by going to "Tools" > "Options" > "Environment" > "International Settings".

Remember to restart after any modifications.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".