How to pass unicode string using Advanced SQL
Question
Application Type
Service

Looks like Text parameter in advanced SQL is passed as Varchar Parameter and hence it is not able to handle unicode strings. I am facing issue when I use advanced SQL to pass some non English text to external database. Text gets passed as '?????'. In .Net generally it is handled by defining the parameter as NVarchar but not sure what is the internal implementation of outsystem when it passes Text using Advanced SQL.It looks like it passes Text as Varchar. Can someone help on this?

Hi again,

Just add here for more detail, you can follow this example:

1. Add Advance SQL widget.

2. Add input as text type and Expand Inline = Yes

3.  In the WHERE of query you can use like this:

4. For passing value:

Regards,

Khuong

Hi again,

Just add here for more detail, you can follow this example:

1. Add Advance SQL widget.

2. Add input as text type and Expand Inline = Yes

3.  In the WHERE of query you can use like this:

4. For passing value:

Regards,

Khuong

For my case it is not search. however same approach  with expand inline worked for me.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.