Subject FreeAdhocUDF: file functions - can not SAVE\LOAD blobs with unicode paths.
Author
Hi guys,

have anyone tried these functions? I can save and load ascii named blobs to disk but it does not work for unicode paths. For example:

SELECT F_BLOBLOAD('E:\你好.txt') FROM RDB$DATABASE gives me an empty blob.

I can not test it via FlameRobin because it is not able to properly create a query with unicode characters in it.

I've tested it with Firebird Maestro but I got nothing (empty blob). The same with Delphi.

It is very frustrating because I do not know where the problem lies:

1. Is CSTRING type a UTF-8 based type? It is required as an input path parameter.
2. Does Database character set can influence this? I've tried setup with NONE and UTF-8, nothing changes.
3. Perhaps those functions are not working with UTF-8 paths, but on the website it is written that they are UTF-8 compatibile (whatever that means?)
4. Perhaps everything is working fine but SQL Maestro is not sendingdata in valid text format, the same goes for Delphi.

I lot of "ifs", maybe someone has some experience with this? Thank you.