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. > > SC> i expect there is somthing like > SC> CREATE TABLE tbl_na

Re: Localization..

2001-08-08 Thread Grigory Bakunov
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. SC> i expect there is somthing like SC> CREATE TABLE tbl_name ( SC> col_name type

Re: Localization..

2001-08-08 Thread SDiZ Cheng
> Hi, > > > > I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as > OS to run MySQL application. In my experience, I have not changed charset > parameter in server startup, database or column. They can store latin1 > and big5 properly "in-a-mix". > > Have u tested to i

Re: Localization..

2001-08-08 Thread shiuwaitai
Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly "in-a-mix". Have u tested to insert and select

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 configuration. > like this: > http://www.mysql.com/doc/C/h/Ch

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 configuration. > like this: > http://www.mysql.com/doc/C/h/

Re: Localization..

2001-08-07 Thread Grigory Bakunov
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 configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html

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

Re: Localization..

2001-08-06 Thread Grigory Bakunov
Date |Tue, 7 Aug 2001 04:01:17 +0800 >From |"SDiZ Cheng" <[EMAIL PROTECTED]> Hello! SC> I have a table which contain data of some different charsets, SC> some of them are multi-byte character.. SC> They are currently stored in raw, binary format.. SC> In order to make % match those multi-byte ch

Re: Localization with MySQL

2001-07-07 Thread tj marlin
my only comment on this is that although you appear to have two different problems - you don't! pick a single solution to both cases; then when your solution needs modification, you only have one set of code to change. this obviously is computer science; only tenuously related to mysql. At 02