Re: RE:Re: RE:Re: Localization..

2001-08-13 Thread SDiZ Cheng
charactors (Big5 or UTF-8 in that column.) which is simular to this example.. > > >- Original Message - > > >From: "shiuwaitai" <[EMAIL PROTECTED]> > >To: "SDiZ Cheng " <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]>

Re: RE:Re: Localization..

2001-08-09 Thread SDiZ Cheng
- Original Message - From: "shiuwaitai" <[EMAIL PROTECTED]> To: "SDiZ Cheng " <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. > > Hi, > > try to use "varch

Re: Localization..

2001-08-08 Thread SDiZ Cheng
> Date |Wed, 8 Aug 2001 03:05:20 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> Yes, i have read that too. > SC> that tell me how to compile mysql with multi charset, > SC> but not create such kind of table. > &

Re: Localization..

2001-08-08 Thread SDiZ Cheng
arset value what problems do u face actually? > > > > Date |Tue, 7 Aug 2001 17:25:48 +0800 > > > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > > > > > Hello! > > > > > > > > > SC> I have read these docs. I

Re: Localization..

2001-08-07 Thread SDiZ Cheng
> Date |Tue, 7 Aug 2001 17:25:48 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> I have read these docs. I can't find any charset option in CREATE TABLE > SC> syntax. > Oh no. > You need to set up charset in mysql c

Re: Localization..

2001-08-07 Thread SDiZ Cheng
> Date |Tue, 7 Aug 2001 17:25:48 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> I have read these docs. I can't find any charset option in CREATE TABLE > SC> syntax. > Oh no. > You need to set up charset in mysql c

Re: Localization..

2001-08-07 Thread SDiZ Cheng
- Original Message - From: "Grigory Bakunov" <[EMAIL PROTECTED]> To: "SDiZ Cheng" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 1:16 PM Subject: Re: Localization.. > Date |Tue, 7 Aug 2001 04:01:17 +0800 > From

Localization..

2001-08-06 Thread SDiZ Cheng
I have a table which contain data of some different charsets, some of them are multi-byte character.. They are currently stored in raw, binary format.. In order to make % match those multi-byte characters correctly, I am planning to convect the table format to correct charset. However, i cannot fi

Re: my sql pattern search and support for backslash??

2001-06-18 Thread SDiZ Cheng
try some more then.. try // or / or .. . > Hi, > I donot even get that with an additional backslash > also.In my case it just ignores the backslash and goes > ahead with the search . > Regards, > Ravi > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On > Mon, Jun 18, 2001 at 04:32:5

Re: Strange Mysql behaviour

2001-06-16 Thread SDiZ Cheng
I think the problem goes here: > PHP4> $result = mysql_query("insert into user values ('$username', > password('$password'), '$email')"); Please ensure $password is correct, and with no problem.. ( eg. space/ at the enter of the string ... etc.. ) --

Re: mysqldump on large database..

2001-06-16 Thread SDiZ Cheng
- Original Message - > In the last episode (Jun 15), SDiZ Cheng said: > > When i use mysqldump, > > seems that MySQL will open all the tables in the database. > > But, what i have is: a database will over 10,000 tables .. > > I get a "Too much opened f

Re: mysqldump on large database..

2001-06-14 Thread SDiZ Cheng
? > > Seung-woo Nam > > SDiZ Cheng wrote: > > >When i use mysqldump, > >seems that MySQL will open all the tables in the database. > >But, what i have is: a database will over 10,000 tables .. > >I get a "Too much opened file" error on this.. >

mysqldump on large database..

2001-06-14 Thread SDiZ Cheng
When i use mysqldump, seems that MySQL will open all the tables in the database. But, what i have is: a database will over 10,000 tables .. I get a "Too much opened file" error on this.. I think increasing open_file_limit is not possible, because of the limit of the OS itself.. Can anyone sugges

Re: Getting MySQL-3.23.35/up working on my box.

2001-06-14 Thread SDiZ Cheng
I have just checked bugs.debian.org . Debian Bug report logs - #81181 gcc: sig 11, reproducible and not machine-specific Somebody have file the same problem, with imapd. not mysql's bug =) -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FA

Re: Getting MySQL-3.23.35/up working on my box.

2001-06-14 Thread SDiZ Cheng
> On Thursday 14 June 2001 08:19, SDiZ Cheng wrote: > > Thanks all.. > > It's up and running now.. > > Seems that is a bug in Debian's CVS version gcc. > > I can't get older version of kernel compile on it too. > > I will move this to debian'

mysqlcheck

2001-06-14 Thread SDiZ Cheng
I can't use "mysqlcheck -m -A" and "mysqlcheck -e -A" It returns with a syntax error.. But i can run "mysqlcheck -A" with no error. It that a known problem? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 -

Re: Getting MySQL-3.23.35/up working on my box.

2001-06-14 Thread SDiZ Cheng
I am using the MySQL offical binary. It's okay now.. Just curious.. what distro and gcc/glibc version MySQL team use to compile their linux binary? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 ---

Re: Getting MySQL-3.23.35/up working on my box.

2001-06-13 Thread SDiZ Cheng
I cannot find the core file.. where is it? BTW, system seems somtimes run out of file handles / max processes. There is some more information to provide: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readab

Getting MySQL-3.23.35/up working on my box.

2001-06-13 Thread SDiZ Cheng
Hi all, I am a new subscriber of this list. I have a question that have confuse me for a long time. I am currently running MySQL-3.23.32 on Debian(woody) with kernel 2.4.x on a i386 box /w 1G Ram.. We are currently runing two different kind of database on the same server. One of them is a few ta