On Fri, 2003-10-24 at 21:06, Wayne Venables wrote: > At 05:39 PM 24/10/2003, you wrote: > >On Thu, 2003-10-23 at 13:31, Wayne Venables wrote: > > > Unfortunately that still means there is a performance hit converting all > > > data in and out of the library from UTF-8 to UCS16. A large number of > > > operating systems and programming languages store strings natively as > > UCS16. > > > >Even if you meant larger than 1% of operating systems AND languages store > >strings > >natively as UCS16, you'd still be incorrect. > > I believe compiling sqlite for UTF-8 should solve my problems. Just have > to pay the conversion price. > > But just for the sake of argument, I will respond. Win32 is unicode > (UCS16). Writing C/C++ w/ Win32 generally involves using wide char > strings. Visual Basic natively stores strings as unicode. Java natively > stores strings as unicode. I'd say that covers a lot more than 1%. And if > you're coding for a non-unicode operating system, I sure hope you're using > unicode anyway or otherwise you're alienating a large portion of users. I > purely ASCII database in this day and age is terribly > backwards. Thankfully, sqlite has the UTF-8 option.
Err, you really think there are less than 300 different operating systems or languages in active use? FYI, nobody said internal use of "unicode" - just "UCS16". Plan9 doesn't. Linux doesn't. Solaris doesn't. BeOS doesn't. All 70-or-so operating systems with the right to call themselves "UNIX" don't. Macintosh don't (no versions). C++ is a language, and it doesn't use UCS-16 internally. Neither does C, which is a completely different language. Pascal doesn't. Delphi doesn't. None of the 600 assembly-languages available have a UCS-16 as their native storage system (excepting invented ones and ones that are for bytecode translation: e.g. Java). You probably meant "most computers" - and even that would be wrong. TRON is the most widely used operating system on the widest number of computers. It is primarily Japanese use and does NOT use UCS-16 internally at all. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
