Re: CONCAT() returns not correct character set

are you converting the text to latin1? It's already there. That conversion seems to be messing things up. Perhaps someone can explain why the conversion messes things up -- seems like a bug to me. -Sheeri On 2/26/06, Hirofumi Fujiwara [EMAIL PROTECTED] wrote: Dear MySQL fans, I

CONCAT() returns not correct character set

))) | +--+ | latin1 | +--+ 1 row in set (0.00 sec) Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http

default characterset of function string parameter

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED] http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japanhttp

Re: How to define utf8 function

CREATE FUNCTION removed CHARACTER SET utf8 part. Why? Hirofumi Fujiwara[EMAIL PROTECTED], [EMAIL PROTECTED] Time Intermedia Corporationhttp://www.timedia.co.jp/ Corporate Strategy Department Knowledge Engineering Center

How to define utf8 function

. Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japanhttp://www.puzzle.jp/ -- MySQL General Mailing List For list archives: http

Re: Can we run linux commands from inside the msql client

you want. Hirofumi Fujiwara[EMAIL PROTECTED], [EMAIL PROTECTED] Time Intermedia Corporationhttp://www.timedia.co.jp/ Corporate Strategy Department Knowledge Engineering Center 26-27 Saka-machi Shinjuku-ku, Tokyo

manual is garbled

Hi, MySQL online manual of Japanese edition is garbled. http://dev.mysql.com/doc/mysql/ja/index.html I think the manuals other than English are garbled. What'a happen? Hirofumi Fujiwara[EMAIL PROTECTED

INSTALL-SOURCE is size 0

Makefile.in -rw-r--r--1 fuji user 1937 7月 23 04:42 README What happen? Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED

I couldn't find cp932 and eucjpms

in set (0.00 sec) mysql Hirofumi Fujiwara[EMAIL PROTECTED], [EMAIL PROTECTED] Time Intermedia Corporationhttp://www.timedia.co.jp/ Corporate Strategy Department Knowledge Engineering Center 26-27 Saka-machi Shinjuku

What is 8-byte address

. Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japanhttp://www.puzzle.jp

Question on hex expression of strings

if this is decided by the specification of MySQL. Will you let me know if this is specified so or this is unexpected behavior? Hirofumi Fujiwara, Knowledge Engineering Center 26-27 Saka-machi Shinjuku-ku, Tokyo 160-0002 Japan Time

SJIS character including 7 bit ASCII code

. --- But it seems that I have to set this option to use SJIS character set. Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japanhttp

Space in multi-byte character set

. It seems that the functions don't process Japanese full-width space as space. Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japan

Re: MySQL and Unicode

I use it with the C API? Thanks. I use unicode(UTF-8) strings as following. mysql_query( mysql, SELECT inlude Japanese characters(KANJI) ); I think that this might answer your question. Hirofumi Fujiwara (Tokyo

Displaying string including Kanji characters

of alphanumeric characters. As far as I could see, the result of functions involving display, such as LPAD and RPAD, doesn't seem to take the display width of Kanji into account. Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL

Re: Displaying string including Kanji characters

Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japanhttp://www.puzzle.jp

REGEXP with UTF-8

. Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED]http://www.pro.or.jp/~fuji/index-eng.html Mirror site http://www.kojima-cci.or.jp/~fuji/index-eng.html -- MySQL

Re: REGEXP with UTF-8

From: Sergei Golubchik [EMAIL PROTECTED] Hi! On Apr 06, Hirofumi Fujiwara wrote: I am testing regular expression feature of MYSQL 4.1.1-alpha (REGEXP) with UTF-8 characters (Japanese). So far it doesn't seem to work. LIKE handles each Japanese character properly as one