When I try to update a table as follows
update Tisk set Barva = 'černobílý' where Barva = 'cernobílý';
the update works but Barva is still cernobílý. How can I fix it?
Asked
Active
Viewed 30 times
0
xralf
- 3,312
- 45
- 129
- 200
-
1What is the data type of the `Barva` column? – Zhorov Nov 01 '21 at 06:53
-
@Zhorov `nvarchar(50)`. From python code, I can set `barva` to `černobílý` – xralf Nov 01 '21 at 06:59
-
4Then you need to prefix the string literals with `N`: `set Barva = N'černobílý' where Barva = N'cernobílý'` – Zhorov Nov 01 '21 at 07:02
-
1You also need to check your column collation. It needs to accent-sensitive, if you want that this works reliably. – Tomalak Nov 01 '21 at 07:04