Skip to content

[QUESTION]I user mssql-django and how to support chinese?When inserting Chinese using SQL , it was found from the database that it was garbled。 #399

Open
@HeroZ09

Description

@HeroZ09

I user mssql-django and how to support chinese? When inserting Chinese using SQL , it was found from the database that it was garbled。

For example:
**test sql below:**
sql_str= "insert into CHECK_TEST (id,TITLE,AUTHOR) values (6,‘**测试哈哈哈哈哈**’,'hero花')"
cursor.execute(sql_str)
**result below:**
(Decimal('6'), '**???????**', 'hero?', None)

I use django mssql setting below:
DATABASES = {
"default": {
"ENGINE": "mssql",
"NAME": "TEST",
"USER": "TEST",
"PASSWORD": TEST,
"HOST": "TEST",
}
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions