Re: Writing Arabic Text to a DataBase with Perl

character_set_system utf8 Also, terminal may not be able to display non-latin characters and you may want to use other clients (GUI clients like MySQL workbench or Navicat, etc.) to test. Hope that helps, Shiva On Mon, Dec 12, 2011 at 3:30 PM, Jon Forsyth jon4s...@gmail.com wrote: Hello Michaël

Re: the best way compare String

-indexing where you only first N characters are used. Best, Shiva On Sun, Dec 4, 2011 at 11:25 AM, Rafael Valenzuela rav...@gmail.com wrote: Hi all, In one query, I am comparing a string with a 'like=%patron%', but is very slow and expensive .What is the best way to compare a string? like

Re: delete syntax

You can try delete from mysql.user where user='mail_admin' and host like '\%' ; Note: I haven't tested it and since % is a wildcard you need to escape it. Best, Shiv On Thu, Dec 1, 2011 at 6:09 PM, Tim Dunphy bluethu...@jokefire.com wrote: Hello Krishna, Thanks but I probably should

Basic Problem Facing towards..

\mass\connect.php on line 25 Can someone plz help me to sort out this problem. Thanx in advance Regards Shiva ps:- login.php ? if ($submit = Login) { mysql_connect(localhost, root,123sw) or die (Could not connect to database); mysql_select_db

Re: Basic Problem Facing towards..

is : How do I install or enable Mysql-support in Php5? Is there any syntax or command which has to be included in Php.ini; OR any other way to enable mysql-support; I'm using Apache 2, Windows XP , Mysql 4.1, php5; Thank you, Regards Shiva - Original Message - From: Hagen

Re: Basic Problem Facing towards..

, and contains MySQL support integrated. I couldnt find any Win32-Precompiled Version from Php.net; Thank you, Regards Shiva ps:- http://dev.mysql.com/doc/mysql/en/PHP_problems.html Still i couldnt fix the problem. 21.3.1 Common Problems with MySQL and PHP

Do Anyone Have Help Material in Pdf Format .. Dummies !

Hallo Everyone, Well can someone please get me some Mysql for Dummies sort of pdf files; Thanx in Advance Regards Shiva ps:- The problem is I'm not able to execute any of the commands after installing Mysql in Windows 2000 P, In short there is only this Red Sign which it is showing

Unable to insert String constants through my function

Hi, I USE THIS FUNCTION TO INSERT VALUES TO DIFFERENT VALUES OF MY DATABASE.. void InsertValues(const string tableName, const string values) { char ValuesToStore[255]; long datasize; char *EncodedData; char *query; strcpy(ValuesToStore, values.c_str()); EncodedData = new

myodbc SQLFetch crash

i am connecting to mysql thru myodbc using iodbc driver manager. when retrieving data, SQLFetch() crashes with SIGSEGV signal. i 'gdb'ed into SQLFetch() and found that it crashed in the very first statement, ENTER_STMT(pstmt). there are no problems when executing SQLExecDirect and SQLBindCols

sqlbindcol

Hi, I am trying to get the following to work but it returns invalid values. SQLINTEGER size; SQLExecDirect (hstmt, Select 8, SQL_NTS); SQLBindCol(hstmt,1, SQL_C_ULONG, size,0,NULL); I tried various datatypes for size but I always get some invalid values. Is the above correct or do I need to

sqlbindcol

Hi, I am trying to get the following to work but it returns invalid values. SQLINTEGER size; SQLExecDirect (hstmt, Select 8, SQL_NTS); SQLBindCol(hstmt,1, SQL_C_ULONG, size,0,NULL); I tried various datatypes for size but I always get some invalid value. Is the above correct or do I need to