I couldn't find cp932 and eucjpms

++ 34 rows in set (0.00 sec) mysql> ---- Hirofumi Fujiwara[EMAIL PROTECTED], [EMAIL PROTECTED] Time Intermedia Corporationhttp://www.timedia.co.jp/ Corporate Strategy Department & Knowledge Eng

What is 8-byte address

s a string. ---- 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

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

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 PROT

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

shell command. I think \! is what you want. ---- Hirofumi Fujiwara[EMAIL PROTECTED], [EMAIL PROTECTED] Time Intermedia Corporationhttp://www.timedia.co.jp/ Corporate Strategy Department & Knowledge Engineering Center

How to define utf8 function

eturns character type is always binary. I want to know how to return utf8 string. 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/

Re: How to define utf8 function

E4BAAC' 1 row in set (0.00 sec) mysql> Returned charater type of function is binary. And, SHOW CREATE FUNCTION removed "CHARACTER SET utf8" part. Why? Hirofumi Fujiwara[EMAIL PROTECTED], [EMAIL PROTECTED] Time

default characterset of function string parameter

+ 1 row in set (0.00 sec) mysql> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---- Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED] http://www

CONCAT() returns not correct character set

nry',CONVERT('abc' USING latin1))) | +--+ | latin1 | +--+ 1 row in set (0.00 sec) ---- Hirofumi Fujiwara (Tokyo JAPAN) enjoy J

Re: CONCAT() returns not correct character set

bianry + latin1 > latin1 (not bianry) > > > > mysql> SELECT CHARSET(CONCAT(_binary'Bianry',CONVERT('abc' USING latin1))); > > +--+ > > | CHARSET(CONCAT(_binary'Bianry',CONVERT('abc' USING latin1))) |

Question on hex expression of strings

; didn't work and I am wondering 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

REGEXP with UTF-8

TF-8 characters. ---- 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

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. &

Displaying string including Kanji characters

le the width 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

Re: Displaying string including Kanji characters

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

Re: MySQL and Unicode

nicode string stored in C, how can 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. -

Space in multi-byte character set

in string. 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]

SJIS character including 7 bit ASCII code

wever. --- 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 Japan