New answers tagged encoding
Errors occured because of unescaped backshlashes. Values preceeded with \ were inrepereted as ascii signs, but they weren't. To avoid this error backslash - \ should be escaped by additional backslash - \ so occurences of backslashes should be changed to double backslashes - \\ .
> SELECT hex(CompanyName) FROM Customers WHERE CustomerID = 'BOLID'; 42F36C69646F20436F6D696461732070726570617261646173 This is not valid UTF-8. That database was not created correctly. If you know what the characters are supposed to be, you could manually fix them: UPDATE Customers SET CompanyName = replace(CompanyName, x'F3', 'ó'); (You'd have to ...
Top 50 recent answers are included