Inserting UTF8 data into SQL Server and it's inserting ? marks

Asked Mar 19 '19 at 15:59

Active Mar 19 '19 at 16:03

Viewed 336 times

I'm executing this piece of SQL in SQL Server Management Studio.

  INSERT INTO cy_company ( cy_company.cy_name, cy_company.cy_address, cy_company.cy_manager, cy_company.cy_number )
VALUES ( '杭州运输公司1', 'Road', '张三', 1234567 )

When I query the table though I'm seeing this:

??????1 Road    ??  1234567

I had been scratching my head all evening as I thought it was my PHP code that was wrong, I've set the encoding to UTF8 in meta, in header and the php files are all UTF8 but I just did a print of the SQL and it's printing fine, when I manually run the printed SQL though it doesn't insert. My IDE also doesn't like showing me values of UTF8 strings properly but when printed it's fine.

The columns are NVARCHAR.

asked Mar 19 '19 at 15:59

Jay Croghan

Declare your literal strings as an `nvarchar`, not a `varchar`. `N'杭州运输公司1'` not `'杭州运输公司1'`, `N'张三'` not `'张三'`. – Larnu Mar 19 '19 at 16:01
Wow. I needed to add that to my SQL too and it's fine. – Jay Croghan Mar 19 '19 at 16:15
@Larnu Your comment should be taken as the accepted answer for this. It works thanks – MindRoasterMir Aug 08 '21 at 19:45

Inserting UTF8 data into SQL Server and it's inserting ? marks

0 Answers0