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:>>
http://cvs.sourceforge.net/viewcvs.py/rira/rira/php/page/search.php?rev=1.1.1.1&view=log>>>
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>
http://lists.sharif.edu/mailman/listinfo/persiancomputing>
--=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
PersianComputing@lists.sharif.edu
http://lists.sharif.edu/mailman/listinfo/persiancomputing