U++ forum: Welcome to the forum

console + sql + unicode or utf [message #32346]

Tue, 10 May 2011 15:18

begnur
Messages: 6
Registered: May 2011
Location: Turkmenistan

Promising Member

I have this code and I cant read non US characters and also pass a character which is not ascci..
for example sql : select * from kelimeler where tur = "��k"

can you help me where is my problem (or what am I doing wrong..)

CONSOLE_APP_MAIN
{
	Sqlite3Session db;
	if(!db.Open(ConfigFile("sozluk.db"))) {
		Cout() << "Veritaban� olu�turulam�yor\n";
		return;
	}
	
#ifdef _DEBUG
	db.SetTrace();
#endif
	
	SQL = db;
	SQL.ClearError();
	
	Sql sql;
	sql.Execute("select tur from kelimeler where ing =\"hi\" limit(10)");
	//for(int i = 0; i < sql.GetColumns(); i++)
	//	Cout() << sql.GetColumnInfo(i).name << "\n";
	while(sql.Fetch())
		Cout() << sql[0] << "\n";
	Cout() << sql.GetColumns() << "\n";
	Cout() << L"T�rk�e Karakterler ����lk\n";
}

by the way my databases is defined as follows

BEGIN TRANSACTION;
CREATE TABLE kelimeler (tur VarChar(100) NOT NULL, ing VarChar(100) NOT NULL);
INSERT INTO "kelimeler" VALUES('ne','what');
INSERT INTO "kelimeler" VALUES('bir','a');
INSERT INTO "kelimeler" VALUES('bir par�a','a bar of');
INSERT INTO "kelimeler" VALUES('bir par�a','a bit');
.
.
.
INSERT INTO "kelimeler" VALUES('gen� eri�kin','young adult');
CREATE INDEX idx_tur ON kelimeler(tur);
CREATE INDEX idx_ing ON kelimeler(ing);
COMMIT;

Report message to a moderator