> 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?
>
---------------------------------------------------------------------
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
