Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread David Jourard
Nils, At 05:30 PM 5/4/04 +0100, you wrote: Basically the best guess would be the documentation that comes with your download. Note that online documents at www.mysql.com are always a mixture of several documentation versions really. Thats the problem. Yesterday, I downloaded 4.0.1x yet the docu

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread David Jourard
Victoria , Thank-you. At 01:35 PM 5/4/04 +0300, Victoria Reznichenko wrote: David Jourard <[EMAIL PROTECTED]> wrote: > > I got the 4.0.17 documentation but when it discusses character sets it > discusses this topic wrt 4.1 > > Where can I find documentation specifica

Documentation on character sets for version 4.0.17

2004-05-03 Thread David Jourard
Hi, I got the 4.0.17 documentation but when it discusses character sets it discusses this topic wrt 4.1 Where can I find documentation specifically in regards to the production version on how to work with, store, and search asian character sets specifically Japanese. Thank-you David Jrt; x-a

Help with search on Japanese and version 4.015

2004-05-03 Thread David Jourard
Hi, I'm implementing a search on fields some using the latin character set and others the Japanese character set; however because its virtually hosted I'm limited to using mysql 4.015 Is the documentation for this version online. I tried to find but could only get for the latest version which

Japanese in version 4.0

2004-01-25 Thread David Jourard
Hi, I need to implement a search in japanese (and also in english). Can 4.0 accept japanese characters and sort them From the documentation I see that it supports: EUC-JP Japanese or Shift-JIS Japanese a. What are the differences btw the two. b. How do i get the mysql to implement the sort.

Whats better increase RAM or CPU for a mysql/perl app.

2002-10-30 Thread David Jourard
Hi List, I have a word search application using mysql and (perl or mod_perl). After all the optimization of code I now want to get a faster box. I have 2 choices: a. box with 1.3 GHZ with 1.5 GIG of RAM or b. 750 MHZ with 3 GIG of RAM These 2 choices are limited by cost. What would be bette

Setup Query to search smallest subset on a Conditional And?

2002-10-21 Thread David Jourard
Hi, In previous e-mail I asked how to improve a word search and used some of the suggestions. Now I'm doing a 2 word search and need a little advice. Background: There are 2 tables: word and content. content consists of 2 fields: rec_id int(11) unsigned not null,

Maximize Performance by Improving Search Program Logic - Help?

2002-10-09 Thread David Jourard
ing this with respect to: A. My definition of fields and their types. B. My queries - it seems that Query 2 could perhaps be made faster. I thank you in advance. It is my hope to increase to 2, 3 and 4 word searche

Re: Perl Interface

2002-03-01 Thread David Jourard
Mike, http://www.gossamer-threads.com/scripts/mysqlman/index.htm Its good. David At 11:51 AM 3/1/02 -0500, Mike Baranski wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >I was wondering if anyone knows of a module for perl to talk to mysql w/o >DBI/DBD. Some sort of shell interface o

Best Free Web Panel for mySQL

2001-12-13 Thread David Jourard
Hi, Could someone recommend the best perl web panel to maintain the databases and tables for mysql. Something similar to phpMyAdmin but in perl. Thank-you David - Before posting, please check: http://www.mysql.com/manual.p