Function to convert UTF16 or binary to UTF-8

[JasperD]

Hi guys,

I've been looking around for a while, but I can't seem to find any functions that convert binary code or UTF-16 to UTF-8?

For example, I'm looking to convert "725B" (UTF-16) into "E7 89 9B" (UTF-8) equivalent.
If it's easier to change decimal or binary to UTF-8, that would work too, but I can't seem to get anywhere...


Thanks for any pointers.

[Alf]

Perhaps this link? See second post.

http://www.pcreview.co.uk/forums/con...-t3825432.html

Alf

[JasperD]

Hi Alf,

thanks for trying to think along - I've found that post as well, but it involves using Word next to Excel.
Apart from that, I found numerous posts which suggest I do it with an ADOdb stream, which I then write to a CSV file.
Would be fine, but I want to prevent writing and opening files - so was looking for an easier way.
I tried to write a stream and then read that stream to a variant, but no luck so far.

I really didn't think it'd be that hard to convert binary/decimal or UTF-16 into UTF-8 ... figured there'd be some 'recode formula', but so far - no luck.
I'll keep digging though, but if anyone would have a suggestion on how to do it with some code.

Ideally if someone can help me understand how to write a 'recoder' as on http://scripts.sil.org/cms/scripts/p...=iws-appendixa

Or on how to make the following code work without writing the file:

Please Login or Register  to view this content.

so I basically will want to read the binarystream into a variant or string - but no clue how.
Anyone?