sp_move_file does not find the file with "č" character in filename

[Andraz]

On UNIX, the Directory and file system procedures do not find the files that use easter european characters. Can anyone confirm?

For example: SELECT sp_move_file('/disk2/temp/Testfileč.txt', '/disk2/temp2/Testfileč.txt');

...returns an error: File or directory not found SQLCODE= -1659

Database: SQL Anywhere 17.0.11.7432, UNIX, UTF-8

EDIT:
CALL xp_write_file('tmp/Testfileč.txt', '123456' ); -- ok
SELECT sp_move_file(N'tmp/Testfileč.txt', N'tmp/Testfileč2.txt'); -- error

Db Property(collation);Db Property(charset);Db Property(ncharcollation);Db Property(ncharcharset)
UCA;UTF-8;UCA;UTF-8

[VolkerBarth]

sp_move_file expects LONG NVARCHAR arguments, whereas you are supplying (LONG) VARCHAR string literal arguments. Does it work if you add a leading "N" to the literal to make it a NVARCHAR literal, such as ...sp_move_file(N'/disk....', N'/disk....') ?

[Andraz]

Actually, the strings used in the database are all NVARCHAR. It does not work even if we use N'/disk....'. We noticed, that all the "new" sp_* functions have this problem, but the functions xp_write_file or xp_read_file do not.

CALL xp_write_file('tmp/Testfileč.txt', '123456' ); -- ok

SELECT sp_move_file(N'tmp/Testfileč.txt', N'tmp/Testfileč2.txt'); -- error

[VolkerBarth]

Well, according to the docs, xp_read_file() and xp_write_file() do treat the filename as LONG VARCHAR parameters, not as LONG NVARCHAR, so that at least may make a difference.

> Actually, the strings used in the database are all NVARCHAR.
What do you mean by that? Do you only use NVARCHAR strings, or do you use CHAR collation with UCA encoding, so both CHAR and NCHAR data are encoded with UTF-8? What does the following return?
select db_property('Collation'), db_property('CharSet'), db_property('NCharCollation'), db_property('NcharCharSet')

[Andraz]

the select (select db_property('Collation'), db_property('CharSet'), db_property('NCharCollation'), db_property('NcharCharSet')) returns:

Db Property(collation);Db Property(charset);Db Property(ncharcollation);Db Property(ncharcharset)
UCA;UTF-8;UCA;UTF-8

[Andraz]

In any case, the sp_move_file does not find the file even if I use N'' or use an nchar variable.

CALL xp_write_file('tmp/Testfileč.txt', '123456' ); -- ok

SELECT sp_move_file(N'tmp/Testfileč.txt', N'tmp/Testfileč2.txt'); -- error