Monty Taylor wrote:
Roy Lyseng wrote:
Monty,
have you considered ICU? You can control everything with ICU, but there
may be some awkward conversions involved sometimes...
That was actually our first thought, but ICU wants everything to be
UTF-16... and the two-byte-per-char hit there seems a bit too expensive
for us to store that way, and certainly ugly if we had to copy
everything to 2-bytes to run the compare... unless I'm missing a mode of
operation?
No, that is also what we found out. However, I think there is a mode
where you do conversion character by character, so you can stop
converting when the compare is done. This can be important for B-tree
lookups, where you can pre-convert the search key, but convert the
B-tree data on demand.
I have never tried out nor benchmarked this stuff, but I imagine the
cache misses is a worse hit than the byte conversions...
Roy
Monty Taylor wrote:
Hey all,
Similar to the charsets conversation, we were also talking about
collations. Currently, of course, we do these per-column, with defaults
available per table and per schema. How useful is this really? What are
people doing who are supporting multi-languages in their systems. Are
they _actually_ storing the multi-language data in different columns
with different collations?
On the other hand, if there was a per-server collation set by locale,
would that be sufficient?
I'm asking for two reasons. One, targeting the cloud rather than the
enterprise, I'm wondering how many people are wanting their database to
handle multi-language sorting directly. The second is that in the quest
to remove our internally implemented charset/collation situation, the
other libs that do this don't seem to have a good way to do per-method
collation picking. So if we don't actually need to have the collation
switch during the lifetime of the process, we can use system locale
processing. If we _do_ there are other, less attractive options...
although we'll do what we have to do I suppose.
Monty
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
