Hi,
try to use "varchar" or "varchar binary" instead.
they work fine in my application for searching '%multibyte%multibyte%' condition even.
>> 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