UTF-8

2004-02-23 Thread Beau Hartshorne
Hi, I am about to start using UTF-8 for my internal data storage and display for a CMS that I'm building. Are there any issues that I should be aware of related to mysql and storing UTF-8 encoded characters? What versions of mysql offer full UTF-8 support, and are there any weird caveats with the

one query, two tables, two aggregate functions

2003-05-31 Thread Beau Hartshorne
Hi, I would like to use one query to compare aggregate values from columns in two separate tables. I am running mysql 3.23.55 (max). Here is a simplified table structure: job - job_id - name quote - quote_id - job_id - quote_amount actual - actual_id - job_id - actual_amount I'm

MySQL and the C API

2003-03-07 Thread Beau Hartshorne
I've been working for some time with php and mysql. I've always been curious, and am finally starting to play with C. I downloaded Paul DuBois' sample Chapter 6: The MySQL C API. I am running Mac OS X 10.2.4. I am running mysql version 3.23.54-max. I followed the instructions in the sample

RE: Perplexed by reverse SELECT statement.

2003-03-04 Thread Beau Hartshorne
Hi Rich, I think that instead of a readBY column in your news table, you should use what's called a lookup table. In this case, the lookup table would store the primary key from the news table and the primary key from the user table. Your table structure might look something like this: user