How to set utf8 as default character set insteasd of lantin1 ?

I'm currently using mySQL 4.1.8 with a bug-tracking application- JIRA. (http://www.atlassian.com/software/jira/) In order to display chinese character in JIRA for bug issues, it needs to have UTF8 character set which we already configured in both JIRA and MySQL. However, when I type "mysql --help"

Re: Insert if Update failed without Select

[EMAIL PROTECTED] wrote: Please also note hat UPDATE returns the number of records updated. If your UPDATE returns 0, you know that the record does not exist, and you might want to INSERT instead. There is one situation where the number of records updated will return 0, yet the row exists.

MYSQL + acquiring table relationships

Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said relationship data. I post to this list as the ability to pull such such informat

MYSQL + acquiring table relationships

Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said relationship data. I post to this list as the ability to pull such such informat

Re: Insert if Update failed without Select

>Please also note hat UPDATE returns the number of records updated. If your >UPDATE returns 0, you know that the record does not exist, and you might >want to INSERT instead. There is one situation where the number of records updated will return 0, yet the row exists. If you update the record w

Re: what permissions are necessary in 4.1.x to allow a user to change their own password

Hello. Use SET PASSWORD=password('youpassword'). On 4.1.9 such queries works fine: mysql> show grants for current_user(); ++ | Grants for [EMAIL PROTECTED]

Re: Error message on Solaris server - help

Hello. Not enough information to make a conclusion. For example, this can be a bug: http://bugs.mysql.com/bug.php?id=6523 where fulltext indexes doesn't work with subqueries. Can you provide a repeatable test case? Can you check if problem remains if you upgrade to latest release? Does my

Re: mysql 4.1.x and openbsd: client library problem

Hello. It is a bug: http://bugs.mysql.com/bug.php?id=6521 "H. Steuer" <[EMAIL PROTECTED]> wrote: > hello guys, > > after compiling and installing mysql 4.1.9 from sources, the database server > seems to work fine, but everything from client/ seems to somehow "hardcode" > the client l

Re: Where are warning messages redirected or logged to ?

Hello. I've looked more carefully through the documentation and source code of mysqlimport. As said in comments at: http://dev.mysql.com/doc/mysql/en/mysqlimport.html MySQL doesn't have the ability to display warnings except in SHOW WARNINGS clause. You can use mysql program with -e op

Update does not doing updates

Hi, I use the following statement to update a table, but I don't see the testing record being updated: $udpate_sql = qq {update transaction set salesvolume=$salesvol, netsales=$netsales, transtype="$transtype", returnreason="$returnreas