Using Unicode and a Microsoft SQL server - Djuggler web scraping and data integration software - Djuggler Forum - Default Group - Community Support

Unanswered Active Topics

Forums Search

Forums > Default Group > Community Support

Using Unicode and a Microsoft SQL server

Last Post 24 Aug 2009 11:47 AM by Support Team. 2 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
Add Reply

Author

Messages

Robbert

24 Aug 2009 11:32 AM
Hi, I tried to insert a Unicode text into a MS SQL server but I get "????" question marks instead of the unicode text. What do I do wrong?

Tijn

24 Aug 2009 11:45 AM
When using the SQL Direct action in Djuggler with Microsoft SQL server you have to put an N before your variables to insert text as Unicode. Like for example in the Microsoft SQL demo included in the Djuggler demo's change the insert statement in line 14 from: insert into persons (first_name,last_name,title,comment) values ('[txtFirstName]','[txtLastName]','[txtTitle]','[txtComment]') to: insert into persons (first_name,last_name,title,comment) values (N'[txtFirstName]',N'[txtLastName]',N'[txtTitle]',N'[txtComment]')

Support Team

24 Aug 2009 11:47 AM
Note: This is standard Microsoft SQL and not Djuggler specific.

Add Reply

Forums > Default Group > Community Support

Quick Reply

toggle

	Username:
	Subject:
	Body:
	Security Code:	Enter the code shown above:
Submit

Powered by Active Forums

	Forum participation and optional registration You don't need to be registered to partcipate in the Djuggler forums, however if you want to subscribe to email notifications you need to register. You can also subscribe to the forum RSS feed.