Shields, Daniel wrote:
Does anyone know the maximum length of the filename passed to sqlite_open. We seem to see truncation on long file names (> 32 chars?)
It's platform dependent and you didn't say which platform, so ... it'll be about whatever MAX_PATH or similar is on your platform. ;) Assuming it's not an embedded platform or DOS 32 chars is way too low.
On Windows, MAX_PATH is 260 and MAX_FNAME is 255 and on Linux, MAX_PATH is 4096 and NAME_MAX is 255. I don't have OS2 so can't help there.
A quick scan of the sqlite3 source suggests that the pathname ends up in a 5000 char buffer on Linux and MAX_PATH+1001+length(pathname) char buffer on Windows. Temporary names are 200 chars.
I tested the max filename length on XP and Debian: Win XP+Python2.5 in c:\Python25 it was 247 chars. Win XP+sqlite shell in c:\tmp it was 244 chars. Debian+sqlite shell in /home/mj it was 247 chars. I don't know why it varies :( but I HTH. Martin ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
