RE: characterset problem 4.1.7

2004-12-06 Thread Francis Mak
tried to change all variables to use utf8, but the problem still exist. Is there anybody could help? Or did I asked the question in a wrong group? Thank you. Francis Mak -----Original Message- From: Francis Mak [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 7:42 PM To: [EMAIL PR

characterset problem 4.1.7

2004-12-03 Thread Francis Mak
, all things become ??? I supspect it is due to the client connection? What config I need to do in order to make php display correctly? Please Please! Thank you very much. Francis Mak

RE: Cannot do join on varchar

2004-07-13 Thread Francis Mak
b_test1.id FROM tb_test1, tb_test2 WHERE TRIM(tb_test1.id)='abcde' AND tb_test1.id = tb_test2.id Anybody could explain this? Thank you. Francis -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 8:19 PM To: 'Francis Mak '; &

Cannot do join on varchar

2004-07-13 Thread Francis Mak
1.id FROM tb_test1, tb_test2 WHERE tb_test1.id='abcde' AND TRIM(tb_test1.id) = tb_test2.id Redhat 9, with MYSQL 4.1.1, using UTF8 as default charset. Any idea?? Thank you. Francis Mak

max length of primary key

2004-01-07 Thread Francis Mak
r exceeded 500? I have a "set-variable= default-character-set=utf8" in my.cnf, maybe this is the cause of error? And is there way to increase this 500 value? Or I must use InnoDB then? Mysql 4.1.1, RedHat 9 Thanks. Francis Mak

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
am self compiled: openssl-0.9.7c -Original Message- From: Duncan Hill [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:02 AM To: [EMAIL PROTECTED] Subject: Re: error 1045 happened randomly On Monday 01 December 2003 11:46, Francis Mak wrote: > I am using PHP4.3.4 + MY

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
he DB 100 times. how could you monitor the number of hits?? by using what tools? thank you guys! -Original Message- From: Wouter van Vliet [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:52 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened rando

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
-TW&lr=&ie=UTF-8&oe=UTF-8&threadm=bkeab v%241bq6%241%40FreeBSD.csie.NCTU.edu.tw -Original Message- From: Wouter van Vliet [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:16 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
Duncan, thanks for your tips. I will give it a try. so this is a known bug in mysql? and for sure using blank password is not a long term solutions, what if it is a share hosting env.? any answer from mysql team? many thanks. francis On Monday 01 December 2003 11:46, Francis Mak wrote

error 1045 happened randomly

2003-12-01 Thread Francis Mak
Hi, sorry if this has been answered previously, however I tried to google, I found a few people having this issue, but no solutions provided. I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 all I did is: grant all on privil