U++ forum: Welcome to the forum

MySqlSession::EnumTables -> why uppercase? [message #5284]

Tue, 12 September 2006 14:46

nicomesas
Messages: 104
Registered: September 2006
Location: Barcelona, Spain

Experienced Member

Hi
I'm develop a small test on MySQL and I get the table names with the function MySqlSession::EnumTables. Well it's work fine, but I have seen that in the code the names of the tables change to uppercase. (line 169 on MySql/MySql.cpp)

Vector<String> MySqlSession::EnumTables(String database)
{
	Vector<String> out;
	Sql cursor(*this);
	if(cursor.Execute("show tables from " + database))
		out = FetchList(cursor, true);
	return out;
}

Soon attempt to make a SELECT on a table (that I have created with another application in windoz) and it select nothing:
I see the session.GetLastError() "skorg_dsrllo_v3.ACTIVIDADES' doesn't exist".

It is rare because the table ' actividades' if it exists, but in lower case. I suppose that this in windoz is no problem because the system is case-insensitive, but not in linux.

I am in the certain thing? I am mistaken? Perhaps I am the only person whom it likes to write the names of the tables in lower case in MySQL?

Good, I propose to so change line 169 of the file MySQL/MySQL.cpp that it so preserve the names of the tables and as the adminstrator decided at its moment.

Nico

[Updated on: Tue, 12 September 2006 14:48]

Report message to a moderator