[V4.5] - Incorrect string value - rbf_setField() on textarea field - Forum - Rollbase - Progress Community

[V4.5] - Incorrect string value - rbf_setField() on textarea field

 Forum

[V4.5] - Incorrect string value - rbf_setField() on textarea field

This question is not answered

Hello,

I have a text area (not Rich Text) field for "description" and I am trying to set the field value of that text area field using the rbf_setField() function. I have an emoji icon in my text that I need to set the field value for that text area field and its erroring out by saying incorrect string value. Any suggestions on how I can fix this issue?

Error Incorrect string value: '\xF0\x9F\x98\x9D\x0D\x0A...' for column 'TXT0' at row 1
 
Cheers.
 
Best Regards,
Iram
All Replies
  • What database do you use? Could you share metadata for RB_OBJ_DATA table?

    mysql> desc rb_obj_data

    or equivalent command for other databases

  • Please see attached file.

    rb_obj_data table.xml

    Cheers.

    Iram

  • Sorry, I asked for the wrong info.

    Which database type do you use (MS SQL or MySQL)? Need to know the collation type for the column

    MySQL command

    show table status where name like 'rb_obj_data';

    MSSQL command

    USE rb_dbo

    GO

    SELECT name, collation_name

    FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'rb_obj_data') AND name = 'txt0'

    I'm not sure about the MSSQL command, you may have to tweak it if that is your database.

  • Hello ,

    We are using MySQL.

    Cheers.

    Iram

  • Can you share the output of the following command then?

    show table status where name like 'rb_obj_data';

  • Hello ,

    The output of the command is given below:

    <?xml version="1.0"?>
    
    <resultset statement="show table status where name like 'rb_obj_data'"
    xmlns:xsi="www.w3.org/.../XMLSchema-instance">
    
    <row>
    <field name="Name">rb_obj_data</field>
    <field name="Engine">InnoDB</field>
    <field name="Version">10</field>
    <field name="Row_format">Compact</field>
    <field name="Rows">1725326</field>
    <field name="Avg_row_length">1572</field>
    <field name="Data_length">2713583616</field>
    <field name="Max_data_length">0</field>
    <field name="Index_length">995868672</field>
    <field name="Data_free">17825792</field>
    <field name="Auto_increment" xsi:nil="true" />
    <field name="Create_time">2017-05-11 23:45:44</field>
    <field name="Update_time" xsi:nil="true" />
    <field name="Check_time" xsi:nil="true" />
    <field name="Collation">utf8_general_ci</field>
    <field name="Checksum" xsi:nil="true" />
    <field name="Create_options"></field>
    <field name="Comment"></field>
    </row>
    </resultset>
  • Hello ,

    Any updates on this issue?

    Cheers.

    Iram