error with "Ñ" character

This is the international (english) support forum for the SQLite Administrator developed and maintained by Orbmu2k.

Moderators: gto, EgonHugeist, Orbmu2k

Daimroc
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 10.10.2012, 10:41

error with "Ñ" character

Postby Daimroc » 10.10.2012, 10:52

I am using the last versión of sqlite administrator, and I have a database versión 3.x that is created with the last command line of sqlite.

I have a table with two fields, one autonumeric for the ID and other that is an string for a code.

I use the following statement:

Insert into MyTable(Code) values('AÑO');

If then I do a select, I see the data correctly, but If then I get the information from the table in a C# application, I get A?O or other odd characters, so I think that the information in the database is inserted incorrectly.

Then, I try other sqlite tool, sqlite spy, and I select the information of the table. I can see that the code "AÑO" is incorrect, it is shown as "A?O", so in this tool, I exceute an update to change the actual value to "AÑO".

If I do a select in this tool (sqlite spy) now the information is correct, and if I do a select in sqlite administrator the information is correct too.

Finally, I execute my C# application and now the information is correct, so I think that there is some bug in sqlite administrator when it is used some special characters.

is it possible to solve this problem in a new version? I really like this application, but this problem is important for me.



Thanks.
Daimroc.

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 10.10.2012, 22:14

Daimroc,
Unfortunately the maintainer of SqliteAdministrator has left his project long ago. We don't even have the sources, so we can't help with a new version.

Sorry,

Mark
Image

Daimroc
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 10.10.2012, 10:41

Postby Daimroc » 11.10.2012, 08:36

I don't know that the project is left.



Thanks.
Daimroc.

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 12.10.2012, 15:39

Only the sqliteAdiministrator project!
Image


Return to “SQLite Administrator”

Who is online

Users browsing this forum: No registered users and 1 guest