Subject RE: [firebird-support] FreeAdhocUDF: file functions - can not SAVE\LOAD blobs with unicode paths.
Author Wodzu

Their mailing list is not working. Which is not a surprise because the last version of UDF is from 2009…

 

Regards.

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of marcus
Sent: Friday, December 13, 2013 3:46 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FreeAdhocUDF: file functions - can not SAVE\LOAD blobs with unicode paths.

 

 

Hej,

brucedickinson@... wrote:

> 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.

Probably the wrong list?
They have a own mailing list: http://freeadhocudf.org/mailing_eng.html