> which version are u using?
> and pls state other info about ur OS!
> using with 3.23.38-max-nt in Windows2000 Advanced Server without problem when I
>search exactly your example.
> about the case "%0xF4 0xF4%", have u really used it to search in where clause,
> or u just want to elaborate ur example?
I am useing Mysql-3.23.39/40 on FreeBSD and Debian Linux,
with default charset "Latin1", column type is "varchar(n) binary"
I didn't try the case "%0xF4 0xF4%", but some unexpected answer
come up when i search for multi-byted 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]>
> >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?
---------------------------------------------------------------------
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
