Storing utf8 text

2003-11-05 Thread Ben Gollmer
Hello list, I'm writing a small utility in PHP to archive email messages in MySQL, so that I can search through them with full-text indexing. In order to handle all the various charsets, I was simply converting all text to utf8 (using mb_convert_encoding()) before storing it in

MySQL 3.23.x, FreeBSD, LinuxThreads

2001-11-26 Thread Ben Gollmer
I recently acquired a new dual-processor (P3 1GHz) workstation, running FreeBSD 4.4-RELEASE. By reading the list, I know that MySQL won't take advantage of both processors unless it is compiled with LinuxThreads support. According to the FreeBSD ports documentation, however, LinuxThreads

Re: New fork of MySQL

2001-11-09 Thread Ben Gollmer
Hmm, this has certainly been an interesting discussion. I personally think that forking the code accomplishes nothing at all. What's so tough about making a patch to 3.23 and sending it to the MySQL developers? I also doubt that anyone working on the new fork will be able to convince

Re: PHP MySQL

2001-06-06 Thread Ben Gollmer
are using htmlspecialchars(), change HTML_ENTITIES to HTML_SPECIALCHARS $trans = get_html_translation_table (HTML_ENTITIES); $trans = array_flip ($trans); $original = strtr ($str, $trans); ? Ben Gollmer Jatosoft, LLC On Wednesday, June 6, 2001, at 01:20 AM, Michele Santucci wrote: I have

Re: ASP and my sql??

2001-05-30 Thread Ben Gollmer
If you are good with C++, you can probably write an ActiveX wrapper for MySQL++ yourself. MS Visual C++ has some wizards that will help you with ActiveX controls. My company considered doing this for a project until we decided to make the app web-based. Ben On Wednesday, May 30, 2001, at

Re: VBA/VB DAO/ADO MS Access to MySQL?

2001-05-29 Thread Ben Gollmer
This works fine from VB6. Install the MyODBC driver (get it from the MySQL web site), then set up a datasource just as you usually would. Ideally, you won't have to change any of your VB code - just bind the ADO/DAO controls to the MySQL datasource rather than the Access datasource. Note

Re: loader

2001-05-08 Thread Ben Gollmer
Specify the format of the text field in your query. For example, if the fields are tab-delimited and each line is a new row, you would use load data local infile 'c:\phani\phani.txt' into table phani1 fields terminated by '\t' rows terminated by '\n'; Ben Gollmer On Tuesday, May 8, 2001

Re: mySQL cache, BLOB, Apache or PHP limits on uploads?

2001-01-15 Thread Ben Gollmer
columns LONGBLOB and you should be good to go. Ben Gollmer Jatosoft, LLC http://www.jatosoft.com/ At 01:02 PM 1/14/2001, you wrote: Hello Readers! I believe I have a upload or a cache limit set too small in a configuration file...I just can't seem to place my eyes on which one. This is what