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

Posted by IramK on 10-May-2017 09:00

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

Rollbase - Forum

All Replies

Posted by Santosh Patel on 11-May-2017 11:08

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

Posted by IramK on 11-May-2017 11:15

Please see attached file.

[View:/cfs-file/__key/communityserver-discussions-components-files/25/rb_5F00_obj_5F00_data-table.xml:320:240]

Cheers.

Iram

Posted by Santosh Patel on 11-May-2017 11:36

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.

Posted by IramK on 15-May-2017 05:47

Hello [mention:7e24e60fbecc4ff8baf4669a65bae0a0:e9ed411860ed4f2ba0265705b8793d05] ,

We are using MySQL.

Cheers.

Iram

Posted by Santosh Patel on 18-May-2017 03:24

Can you share the output of the following command then?

show table status where name like 'rb_obj_data';

Posted by IramK on 18-May-2017 03:44

Hello [mention:7e24e60fbecc4ff8baf4669a65bae0a0:e9ed411860ed4f2ba0265705b8793d05] ,

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>

Posted by IramK on 24-May-2017 04:18

Hello [mention:7e24e60fbecc4ff8baf4669a65bae0a0:e9ed411860ed4f2ba0265705b8793d05] ,

Any updates on this issue?

Cheers.

Iram

This thread is closed