Re: Writing Arabic Text to a DataBase with Perl

t_server latin1 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 wrote: > Hel

Re: the best way compare String

ee if you can make use of prefix-indexing where you only first N characters are used. Best, Shiva On Sun, Dec 4, 2011 at 11:25 AM, Rafael Valenzuela wrote: > Hi all, > In one query, I am comparing a string with a 'like=%patron%', but is very > slow and expensive .What is

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 wrote: > Hello Krishna, > > > Thanks but I probably should have noted that I only

Re: Basic Problem Facing towards..

icial PHP site, 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 w

Re: Basic Problem Facing towards..

uestion 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

Basic Problem Facing towards..

Files\Apache Group\Apache2\htdocs\mass\connect.php on line 25 Can someone plz help me to sort out this problem. Thanx in advance Regards Shiva ps:- login.php create_entry.php You are now registered Go back to main page index.html

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

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 char[strl

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

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