SQLite Forum

zero width space
Login
Hi All, I find in Indian texts '\u200d'. It appears for instance in 'अमिताभ बच्\u200dचन'.
This \u200d seems to be a zero width space. 
I cannot replace it by a space, and I cannot replace it by nothing because then it will no longer be a substring found in another string. 
So I need to replace it by an actual character, even if this won't show up on the screen. 

Does anyone know how to go about this? Is there a function in SQLite to convert a unicode entity to an utf-8 character? 

thanks

gert