Hi! > Darren Duncan wrote: > > > > Can you also copy [SQLite database] files between computers which have > > different CPUs, especially between big-endian and little-endian > > architectures, and have it just work? > Yes Hehe, short answers today ;-)
The long answer: The database is organized the way the system is where the file has been created. If you create your database on a big endian maschine it is organized big endian-like and if you create it on a little endian maschine the file becomes little endian organized. If you then open the file on another platform SQLite recognizes the endianess and stores all data in the format of the file and converts all values read. This mechanism works quite well, but I am not sure if you will get a performance degree on the 'other' platform, that has to marshall it's values. So if you don't need the file on the original platform anymore, it may be wise to recreate the file on the new platform. Maybe anybody has measured the effect of marshalling? It should be quite low, but who knows... - Danny -- Danny Reinhold Reinhold Software & Services --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
