brodycj
commented
7 years ago Hmm. I tested on a Samsung Galaxy J3 with Android 5.1.1 with some multi-byte UTF-8 characters in spec/www/spec/db-tx-string-test.js lines 462-498 OK:
it(suiteName + 'UTF-8 string test', function(done) {
if (isWP8) pending('SKIP for WP(8)');
var db = openDatabase("UTF8-string-test.db", "1.0", "Demo", DEFAULT_SIZE);
db.transaction(function(tx) {
tx.executeSql("SELECT UPPER('Test ¢ é €') AS upper_result", [], function(ignored, rs) {
if (isAndroid && (isWebSql || (isImpl2 && /Android [5-9]/.test(navigator.userAgent))))
expect(rs.rows.item(0).upper_result).toBe('TEST ¢ É €');
else
expect(rs.rows.item(0).upper_result).toBe('TEST ¢ é €');
// Close (plugin only) & finish:
(isWebSql) ? done() : db.close(done, done);
});
});
}, MYTIMEOUT);
it(suiteName + 'UTF-8 string binding test', function(done) {
if (isWP8) pending('SKIP for WP(8)');
var db = openDatabase("UTF8-string-binding-test.db", "1.0", "Demo", DEFAULT_SIZE);
db.transaction(function(tx) {
tx.executeSql('SELECT UPPER(?) AS upper_result', ['Test ¢ é €'], function(ignored, rs) {
if (isAndroid && (isWebSql || (isImpl2 && /Android [5-9]/.test(navigator.userAgent))))
expect(rs.rows.item(0).upper_result).toBe('TEST ¢ É €');
else
expect(rs.rows.item(0).upper_result).toBe('TEST ¢ é €');
// Close (plugin only) & finish:
(isWebSql) ? done() : db.close(done, done);
});
});
}, MYTIMEOUT);Can you post a small, self-contained program that demonstrates this issue?
ghost
aharslan
Heya. First of all I wanna thank you for maintaining this awesome plugin. I'm almost finishing my first Ionic App but still facing some problem when testing it on a Zenfone 2. My DB rows were written in portuguese, and so there is a lot of accentuation. My app seem to work fine on most cellphones but something is going weird when I deploy it on a Asus Zenphone 2 (androd 5.5), as you can see on the screenshots.
I'm using UTF-8 on sqlite. Have you ever faced something like that? Thanks a lot in advance.