Unicode in Parameter passing?

(2 posts) (2 voices)


No tags yet.

  1. spyhunter88, Member

    Hi team,

    I has found an issue about parameter passing if it has unicode character. My code and export:

    -- inProvince is a parameter of this procedure
    SET inProvince = IFNULL(inProvince,'');
    select 'dbr.report','sp_DBR_Sales_Line_Details_v2', 'new_popup', '[Sales]', concat('inProvince="',inProvince,'"');
    select 'dbr.report', 'sp_DBR_Sales_Line_Details_v2', 'new_popup', '[Sales]', 'inProvince="Cần Thơ"';
    select 'dbr.subtitle', 'Sales by  >> Province: Cần Thơ';
    select 1 as 'Quantity', 111111111 as 'Sales', 111111110 as 'Cost', 1 as 'GP[GP]';

    And now in the Sales Line Details report, I receive Cần Thơ" with double quote follows, if inProvince='others' it works without double quote.


  2. myDBR Team, Key Master

    this has been fixed in the latest build. Thanks for pointing this out.

    It is generally easier to pass the variables in the result set rather than in the constants.

    myDBR Team


You must log in to post.