Getting Unicode strings from element in List view

[smart]

Hello,

I hit a road block here. lol.
Element has a unicode value and it needs to be processed in the calc element for the result to be shown in the list.
Element value comes like this below when "{table___element}" is used in calc php code.

"https:\/\/archive.org\/download\/DZGSBV0027A\/\u1026\u1038\u1003\u1031\u102c\u101e\u102d\u1010\u102c\u1018\u102d\u101d\u1036\u101e_\u1042\u1040\u1042\u1040_\u1014\u1036\u1014\u1000\u103a\u1001\u1004\u103a\u1038\u1021\u101c\u102f\u1015\u103a\u1015\u1031\u1038\u1010\u101b\u102c\u1038\u2212\u1041\u1045\u1043.mp3"

I tried to convert several ways but nothing works.
What will be the proper way of getting the Unicode value to be shown in list view?
Thanks

 

[troester]

Where does this come from?
What is your database/table/column collation?

 

[smart]

Thanks Troester,

1) This value comes from mySQL column.
2) Table and column collation is utf8_general_ci. It can be displayed correctly on the form element.
I don't know how to process it (mainly trimming & concatenating) and show it again from the calc element.

 

[troester]

Which element type is your "{table___element}" used in the calc?
You say in the form table___element is showing correctly, how is it in details and list view?
What is your calc code?

 

[smart]

tk___kiaAlink element type is "Link".
In Detail view it shows correctly I can see / edit those Unicode chars in the link field.
On list, it represented with Icons but the link works perfectly.
But I have hard time getting its data to this calc php below.
I am not a php programmer so I have to study and test those.

$DBlink = '{tk___kblink}';
$DALink = '{tk___kiaAlink}';

$DALink = mb_convert_encoding($DALink, "UTF-8");

$Starlink = "";

if (!empty($DALink)) {
  $Starlink = $DALink;
} elseif (!empty($DBlink)) {
  $Starlink = $DBlink;
}

return $Starlink;