Skip to main content
Completed

Change the tsf_send_message parameter datatype to nvarchar

Related products:Software Factory
  • Dennis van Leeuwen
    Dennis van Leeuwen
  • L
    Laurens Wolf
D
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.

Did this topic help you find an answer to your question?

5 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
Updated idea status New → Open
"Wake me up before you low-code" | On holiday 06-02 till 27-06
Mark Jongeling
Administrator
Forum|alt.badge.img+23

Updated idea status Open → Working on it!

"Wake me up before you low-code" | On holiday 06-02 till 27-06
Mark Jongeling
Administrator
Forum|alt.badge.img+23

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:

 

"Wake me up before you low-code" | On holiday 06-02 till 27-06
Jeroen van den Belt
1 person likes this
  • Jeroen van den Belt
    Jeroen van den Belt
Mark Jongeling
Administrator
Forum|alt.badge.img+23

Updated idea status Working on it!→ Next release

"Wake me up before you low-code" | On holiday 06-02 till 27-06
Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Updated idea statusNext release→Completed

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings