Jim Starkey wrote: > Brian Aker wrote: >> Hi! >> >> On Sep 3, 2008, at 7:27 AM, Jim Starkey wrote: >> >>> For timestamps, standard syntax. For numbers, "<name> number [ scale >>> <decimalScaleFactor> ]". For strings, "<name> text". All text is >>> internally UTF-8, though that isn't externally visible. Blobs /clobs >>> are a threshold for separate storage rather than distinct types. The >>> legacy SQL types will be recognized as quaint, but acceptable. >> >> We are on the same page then. I haven't pulled the TINY/SMALL code >> yet, but it will be gone soon. All of the int(12) is gone. Medium has >> been gone for a while (I mean... 24bit int?). >> >> By external on UTF8... what do you mean? How are you handling your >> collations on UTF8? At this point I have yet to find a good free >> library to do it. Very soon Drizzle will be end to end UTF8. Clients >> will only accept it, and I am just requiring clients to handle the >> conversion themselves. This means native conversion should work for >> almost everything. > I'm planning to use ICU (IBM's International Components for Unicode) for > the actual collations. It's licensed under MIT's X11 license, and is > GPL compatible.
We investigate ICU a month or so ago. Looks good, but the number one reason it was decided not to go forward was because it is natively UTF16, and we weren't willing to go down that route at the moment. The current plan is to remove charset support entirely within drizzle (krow is already working on that) and use the current collation system as-is, while fixing any bugs we find. > Putting character set conversion in the client is absolutely the right > way to do. There is no earthly reason for a database to handle multiple > character sets. +1. :) Cheers, Jay >> Your constraint argument makes sense. I need to poke around and see >> how many other DB's have syntax and what they are using. I know that >> PG uses a subset of the SQL int types. >> > > _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
