Is it possible to support single and double byte characters in the same database?

2002-03-13 Thread Kim Albee
Is it possible to support both single and double-byte characters in the same database? We have offices all over the world -- and want to share information, but in some cases, there will be japanese and possibly hebrew text in the database - in addition to English, Dutch, french, and Spanish. Is

JDBC Connection Error: Server Config denies access...

2002-02-12 Thread Kim Albee
I am using mySQL 3.23.36 for RH Linux (came with the 7.1 install). I am using mm.mysql-2.0.7-bin.jar JDBC driver. When I attempt to connect, I am getting a Server Configuration denies access... error. When I have gotten this error in the past, it's been because the user wasn't set up with the

Optimizing mySQL for volume

2001-12-27 Thread Kim Albee
We are trying to optimize mySQL. Right now, the max_connections is set to 100. We are only able to open 99 concurrent connections to the db, and even then, some requests are unable to get a connection. We'd like to be able to scale that up, but mySQL doesn't like what we've done, as it won't

How do I turn the Query Log option OFF?

2001-05-02 Thread Kim Albee
I need to be able to turn the Query log option off, and cannot figure out how to do that. I have enabled --log-bin logging, to capture any update commands, but cannot figure out how to turn query logging off. In the mySQL doc it says to alter the mysql.server script -- but nowhere in the script

configuring mysql log files

2001-04-10 Thread Kim Albee
My database log files are expanding very quickly - and when I look at them, they are logging all of the select statements, not just the delete, insert, update, etc. statements. How do I specify for the logfiles to only log "update" statements and not the selects? Thanks,

Support for double-byte characters retrieving

2001-04-03 Thread Kim Albee
I am using mysql to store content that will contain double-byte (korean, japanese) language text -- What is it that I need to specify when inserting that type of text (if anything) and how do I retrieve it? I am writing in Java using JDBC to a mySQL database. Thanks, Kim Albee