Subject | FreeAdhocUDF: file functions - can not SAVE\LOAD blobs with unicode paths. |
---|---|
Author | |
Post date | 2013-12-13T14:04:58Z |
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.
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.