Article - CS354448
How to use Unicode SQL query (prefix N) against SQL Server database in ThingWorx Platform
Modified: 28-Nov-2023
Applies To
- ThingWorx Platform 9.0 to 9.3
Description
- How to use Unicode SQL query (prefix N) against SQL Server database using Database Thing
- Sometimes, we need to write SQL to specify prefix N to update/query unicode string, E.g:
update testtable1 set n_name=N'张三'
- How to write the SQL inside ThingWorx Database Thing to make use of the prefix N
This is a printer-friendly version of Article 354448 and may be out of date. For the latest version click CS354448