[Webkit-unassigned] [Bug 54384] Use UTF-8 instead of UTF-16LE for Database Storage

[bugzilla-daemon at webkit.org]

https://bugs.webkit.org/show_bug.cgi?id=54384





--- Comment #2 from Christian <christian.gerhardt.79 at googlemail.com>  2011-02-19 09:22:54 PST ---
> > the space required for storing data is about 3 times higher
> What is your native format? The difference between UTF16 and UTF8 or Latin1 is only factor 2!

The additional space should come from the indexes, which the Web SQL database seems to add for every primary key.

Example:
A table DATATABLE with primary key "primary" creates the following indexes
- on Android database (native - UTF8):
    ==> sqlite_autoindex_DATATABLE_1

- on WebView database (web-based - UTF-16le):
    ==> sqlite_autoindex_DATATABLE_1
    ==> idx_primary

An additional index should mean additional space, so having several tables means several primary keys and therefore several indexes. 

As shown before in our current project, the size of the WebView database is almost 3 times the size of the Android database.

-- 
Configure bugmail: https://bugs.webkit.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.