sqlite + Unicode

[d0n]

I have a sqlite database with some chinese characters in it

However when i import that into a GUIListview it turns into garbage

I tried using this but nothing happened

_GUICtrlListView_SetUnicodeFormat($ListView1, True)

Edited December 3, 2009 by d0n

[BrettF]

What sort of garbage? Is the SQLite database able to handle unicode?

[d0n]

yea it works fine in when i open the .db with SQLite expert, but when i load the data into a listview it turns into garbage

æ–°èž

this type of garbage, kinda changed a bit when i copied from listview into here

[BrettF]

Version of AutoIt? There was something with unicode but I can't remember it.

[d0n]

v3.3.0.0 from the help file

[jdefockert]

Hi,

I have a similar problem but with German.

In the SQLite DB the string look like this: "Hinzufügen", but when I retrieve the string with the function _SQLite_QuerySingleRow it comes up as "Hinzufügen". The double byte character "ü" has been replaced with 2 garbage characters.

Any help or ideas would be greatly appreciated.

Kind regards,

Jasper

[d0n]

anyone help?

[ProgAndy]

I think, SQLite saves the data as UTF-8, but the functions return it as ANSI. So try this: First get the bytes from the string and then reinterpret them as UTF8

$sUTF8 = BinaryToString(StringToBinary($sString, 1), 4)

Edited December 5, 2009 by ProgAndy

[d0n]

Hi, that worked for the reading part. Reading the SQLite database for unicode and inserting them into the Listview.

I was wondering how it will work if i want to write some data as unicode, i tried playing around with the code you posted, but i couldn't get it to show the unicode.

$Input = InputBox("Modify", "Enter new", "", "", 250, 50)
;add the new unicode data into SQLite

[KaFu]

With something like this:

$UnicodeString = "ελληνική γλώσσα"
_SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('c'," & BinaryToString(StringToBinary($UnicodeString , 4), 1) & ",'World');") ; INSERT Data

[d0n]

got it working, Thanks for helping everyone!

[jchd]

got it working, Thanks for helping everyone!

Hi,

This is no more a problem with the latest SQLite UDF, which handles native AutoIt Unicode strings nicely without requiring anything else.

[DerMedizinmann]

$sUTF8 = BinaryToString(StringToBinary($sString, 1), 4)

... Yeahh! Thank you very much, Andy. This helps me a great deal!