You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a SQL script encoded in UTF-8 that contains insert statements with unicode strings that are inserting in a NVARCHAR field. When I run this script, the data inserted in the table is malformed.
Example:
CREATE TABLE homeInstitution
(
id INT IDENTITY(0,1) NOT NULL PRIMARY KEY,
institution NVARCHAR(128) NOT NULL,
deletedDate DATETIME NULL,
);
INSERT [dbo].[homeInstitution] ([institution], [deletedDate]) VALUES (N'Lycée ÀÉÙÇÊÏ', NULL)
If I convert the file to ISO-8859-1 format, the data is inserted correctly
The text was updated successfully, but these errors were encountered:
etiennellipse
changed the title
.run with a utf-8 script with unicode strings with N' prefix does wrong conversion
.run with a utf-8 script with unicode strings does wrong conversion
Apr 16, 2019
Version: 0.6.2
MacOS 10.14.4
Node v10.15.2
I have a SQL script encoded in UTF-8 that contains insert statements with unicode strings that are inserting in a NVARCHAR field. When I run this script, the data inserted in the table is malformed.
Example:
.run myfile.sql
select * from homeInstitution
Result:
The text was updated successfully, but these errors were encountered: