Re: [sqlite] A proposal for SQLite version 3.0

2004-04-09 Thread Andrew Carter
Windows UTF-16 is represented by WCHAR. It is always 2 bytes. UCS-2 can be 3 or more bytes but these are for extended characters outside the ones used for real language. For example, musical notation symbols use the third byte. I don't think any OS's use UCS2 directly. I know Oracle supports

Re: [sqlite] A proposal for SQLite version 3.0

2004-04-09 Thread Andrew Carter
I'm assuming UTF-8 support will still be there as well? For Windows applications, UTF-16 is much more prevalent. -- Andrew On Wed, 7 Apr 2004, Christian Smith wrote: > On Wed, 7 Apr 2004, D. Richard Hipp wrote: > > >A design proposal for SQLite version 3.0 can be found at: > > > >

Re: [sqlite] Looking to possibly use sql lite

2004-02-12 Thread Andrew Carter
SQLite should be used when you are writing applications in which you do not want the user to even know they are using a database. It is embedded only and isn't designed with security or concurrency to support a mutli-user load like PostgreSQL/MySQL/Oracle/Microsoft SQL Server. Something like