Problem with revExecuteSQL - More

[Ian Wood]

It looks like the folder name has been abbreviated at some stage by  
an OS that didn't understand file/folder names that long.

Where *exactly* is the filepath coming from?

Ian

On 1 Nov 2007, at 18:01, Dave wrote:

> However I now have a another weird problem, I have a field that  
> represents a file path, in this case the path is:
>
> /Users/Dave/Music/iTunes/iTunes Music/Blank & Jones/Addicted To  
> Trance (Disc 1)/11 DJs, Fans And Freaks.mp3
>
> However a "if there is a file" fails on this path. When I look I  
> can't see the & in the file name. I'm guessing it's something  
> to do with UTF16 vs UTF8 or something, but I'm not sure how to  
> resolve it. The database I am writing is set to UTF8 which AFAIK is  
> the only option for SQLite.