----- 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 "varchar" or "varchar binary" instead.
> they work fine in my application for searching '%multibyte%multibyte%'
condition even.
I have tried that.
MySQL match all rows i needed.
But i match some row i don't want too..
let me show you an example...
The charactor "中" in Big5 chinese is 0xA4 0xA4.
The charactor "水" is 0xA4 0xF4, "鐀" is 0xF4 0xF4.
To match "鐀", we should use "%0xF4 0xF4%", which,
in result, it match "水中" .. 0xA4 0xF4 0xA4 0xA4 too..
i just don't want this kind of cross-charactor match happend.
>> 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 your records with different charsets
> >> in MySQL before changing the value of charset?
> >>
> >
> >the table i want to create is of mixed charsets, ie:
> > Title VARCHAR(10), <--- Latin
> > desc_b5 VARCHAR(10), <--- Big5
> > desc_gb VARCHAR(10), <--- GB2312 ....
> > desc_en VARCHAR(10), <--- ASCII ....
> > desc_(some other charsets...)
> >
> >I am now using a simple BINARY option to make
> >this (seems) possible. INSERT work fine with this.
> >
> >However, _SELECT col_name from tbl_name
> >LIKE '%(somthing)%';_ doesn't work as expected
> >with multi-byted charsets... MySQL try to match
> >across two characters.
> >
> >I don't want to use Unicode in this, as Unicode
> >is not a complete superset of all charset i have to use,
> >there will be some losses when i convect to other charsets..
> >
> >That's why i am asking here.
> >
> >> Beside setting charset 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 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
> >>
> >>
> >>
> >> Yes, i have read that too.
> >>
> >> that tell me how to compile mysql with multi charset,
> >>
> >> but not create such kind of table.
> >>
> >>
> >>
> >> i expect there is somthing like
> >>
> >> CREATE TABLE tbl_name (
> >>
> >> col_name type CHARSET=char_set,
> >>
> >> col_name2 type CHARSET=char_set2 ) ...
> >>
> >>
> >>
> >> CREATE DATABASE db_name DEFAULT_CHARSET=char_set ....
> >>
> >> where can i find these?
> >
> >>
> >
> >
> ==================================================================
> 新浪免費電子信箱 http://sinamail.sina.com.hk
>
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
