|
|
2010-07-29, 09:25 AM
|
#1 |
|
Registered User
Join Date: Jul 2010
Posts: 1
|
Much the same problem
Hi, I'm building a .sqlite database with a service built in java (using the SQLJetDB lib) and the DB is created fine. It's UTF-8, and when I browse the DB with the Firefox SQLite Manager plugin, I see all my data in there, even trademark and copyright symbols. When I query the database from within flash, I'm getting garbled characters (specifically, we have Bluetooth(r) that comes into flash as BluetoothAr).
I've noticed in your World.db in the example, the characters show up in my SQLite Manager as questionmarks in black diamonds instead of say the n with the ~ over it. So, how did you insert the data into the database? Or, is there a way to set the encoding coming out from the database? |
|
|
|
2010-07-30, 02:34 AM
|
#2 |
|
Plugin Developer
Join Date: Jun 2002
Location: Germany
Posts: 2,327
|
Hi JImi,
the world.db was created using the sqlite.read command, which should work fine if the file you are reading is in UTF-8 (without BOMs) ANSI-encoded files should work as well. Currently there is no way to set the encoding the sqlhelper is using. However the new sqlite plugin should not suffer from this problems, if you wanna give it a try drop me a mail at support @ software-and-solutions.de |
|
|
|
Hybrid Mode