Hi,
I'm using SQLite with Vb.net, concretly:
- Visual Basic Net 2008
- Dll "sqlite-netFx35-binary-bundle-Win32-2008-1.0.91.0"
I'm create a database with "sqliteadmin" and the database is UTF8 encoding,
but when i reading data and charge in a listview or combobox the especial
characters like "ñ" or "á" don't appears.
My code:
Dim SQLconnect As New SQLiteConnection()
Dim SQLcommand As SQLiteCommand
SQLconnect.ConnectionString = "Data Source=" &
Application.StartupPath & "\bd_ejemplo.s3db;"
SQLconnect.Open()
SQLcommand = SQLconnect.CreateCommand
SQLcommand.CommandText = "SELECT * FROM Nombres"
Dim SQLreader As SQLiteDataReader = SQLcommand.ExecuteReader()
lstbocatas.Items.Clear()
While SQLreader.Read()
lstbocatas.Items.Add(New ListViewItem(New String()
{SQLreader(0), SQLreader(1).ToString}))
End While
SQLcommand.Dispose()
SQLconnect.Close()
I want to know is is a bug of DLL, basic or is my error.
Sorry for my bad english.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
