Hi,
I have a problem especially executing the query, I hope the problem due to special Character, i am using the ADOB for DB[MYSQL], Script is PHP, i have enclosed the function which make me hazard …….
define('QRY_ALTER_CATEGORY', 'ALTER TABLE Category ADD %s');
function ChangeCategory($FieldName) {
$Condition = $FieldName.' VARCHAR(20)';
$Query = sprintf(QRY_ALTER_CATEGORY,$Condition);
$this->core->DBConn->Execute($Query);
}
The above Function use to Alter the Table Field name ,the problem is : if the Filed name is "Special character [íóÓéèÉÈÚúáàÁÀãñÑÖöÜüßÉ]” means the query is not execute other wise its works well ,please let me know the solution for the problem ,and expecting positive reply and advance thanks for the same .