Hi,I have a database (MySQL 4.0)  that using Arabic-1256 encoded data. Iwant to 
convert all of tables to UTF-8.I can not download, convert and upload the 
database becasue of thesize of DB and my connection speed. Any one have any 
idea to convertby code (PHP, Perl, ...)
- Sadeq
On 12/5/05, Behdad Esfahbod <[EMAIL PROTECTED]> wrote:> On Wed, 30 Nov 2005, 
AmirBehzad Eslami wrote:>> > Dear Behdad,> >> >   On 25 Nov 2005, you wrote:> 
>> > > Another options is to get yourself a real search engine, like> > > 
Apache Lucene. I've written my experience using that here:> >   >> > > 
http://mces.blogspot.com/2005/04/on-lucene-and-its-decency.html> >> > You 
always offer the most brilliant solutions!!> > Unfortunately, I have no 
experience with this mehotd. But I'm still eager.> > I read your weblog and met 
"Apache Lucene" homepage.> >> >   I'm impressed. Would you tell us how you have 
integrated this> > Java-driven package with PHP at http://rira.ir/ ?!!  It 
works> > really fast.>> That's the tricky part, or where the runtime-hell comes 
in.  What> I did was to write a small java program based on the samples in> 
Lucene to connect to my database and feed the data into Lucene.> At search 
time, I have another little Java program that takes the> query string fro!
m command line and prints out search results to> standard output.  My PHP 
script then just fires up a shell script> that in turn runs the Java program, 
piping the output into PHP...>> I don't have access to the Java codes at this 
time, but the PHP> code involved is available here:>>   
 If you are developing in .NET, there is a functional port of> Lucene to .NET 
too.  There is even a port of an older version of> it to Python.>> BTW, you 
need to make sure you compile it with Unicode turned on.> I don't quite 
remember the details, but there was some.  I also> have a Persian class written 
for it, but it didn't do much> anyway.  In a few weeks I will get access to 
rira.ir server and> hopefully move the site to the above sf.net project, so you 
can> see what's inside.>> > Thank in advance,> >   Behzad>> Cheers,>> --behdad> 
http://behdad.org/>> "Commandment Three says Do Not Kill, Amendment Tw!
o says Blood Will Spill">         -- Dan Bern, "New American !
Language"> _______________________________________________> PersianComputing 
mailing list> PersianComputing@lists.sharif.edu> 

--=========================Phone:  +98 (351) 626 7581 | 725 7974Fax:    +98 
(351) 725 7974 | 622 6117Mobile: +98 (913) 153 0551Website:    www.DSI.irLinux 
Number:     278869=========================
                o             _ /<.            (*)>(*)
PersianComputing mailing list

Reply via email to