Completed

Change the tsf_send_message parameter datatype to nvarchar

Related products:Software Factory

Forum|Forum|5 years ago
July 21, 2021
5 replies
153 views

Dries Fransen
Apprentice

Currently, when I want to send a message through the tsf_send_message stored procedure with a parameter that contains non-latin characters, such as Cyrillic and Thai, these characters are all converted to question marks.

i.e. <TEXT>"ภาษาไทย Phasa thai"</TEXT> becomes <TEXT>"??????? Phasa thai"</TEXT>.

However, as was noted in the answer to the related question, by changing the datatype of the tsf_send_message function from varchar to nvarchar, the use of non-latin characters in parameters will become possible.

+23

Mark Jongeling
Software Architect
Forum|Forum|5 years ago
July 21, 2021

Updated idea status New → Open

"Wake me up before you low-code"

Like

+23

Mark Jongeling
Software Architect
Forum|Forum|4 years ago
July 29, 2021

Updated idea status Open → Working on it!

"Wake me up before you low-code"

Like

+23

Mark Jongeling
Software Architect
Forum|Forum|4 years ago
July 29, 2021

Hi Dries,

This idea has been implemented in the 2021.3 version of the platform and will be reviewed by my colleagues to ensure everything is made well. Not only the tsf_send_message is affected, but also the tsf_send_progress and tsf_send_assertion_msg since these procedures share the same datatype for the @parmtr_string parameter. So you can use non-Latin characters, like Thai and Chinese, in those procedures too when executing them in SQL-code :wink: