Why isn't Cyrillic written in the MS-SQL text field?

Question

Yii

There is a field in MS-SQL, windows-1251 encoding, text type. Through activeRecord, the value of the "address" field (Cyrillic) is added, the following query is formed:
INSERT INTO [Orders] [Address]) VALUES (0xc8ecff20d4e0ece8ebe8ff20cef2f7e5f1f2e2ee)
An error appears: "Operand type conflict: varbinary is incompatible with text". On the varchar type, everything is fine. What to do?

Answer 1

PDO in PHP7 has such a bug. Rolled back to php5.

Answer 2

use the correct types to store data. if the address field is only 30 characters at a glance, why do it text? The text, contrary to the name, is intended for storing a large amount of data.

Answer 3

Probably not enough quotes.
But I would not use the TEXT type if I were you - it will be abandoned in new versions. Use nvarchar(max)

Answer 4

The error appears: "Operand type conflict: varbinary is incompatible with text". On the varchar type, everything is fine. What to do?

Use nvarchar(max)

It makes more sense to use the varbinary(50) type, or whatever length you need.

Answer 5

for normal work with Unicode use nchar and nvarchar.