Re: Chinese characters not displaying in Workbench latest version

; What are you using to view the data? >>> >>> On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote: >>>> ;>>> 2011/11/20 20:27 +, Tompkins Neil >>>> >>>> Does anyone know why Chinese characters are not displaying correctly >&

Re: Chinese characters not displaying in Workbench latest version

Neil Tompkins wrote: > MySQL workbench > > On 21 Nov 2011, at 13:36, Chris Tate-Davies wrote: > > What are you using to view the data? > > > > On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote: > >> ;>>> 2011/11/20 20:27 +, Tompkins Neil >

Re: Chinese characters not displaying in Workbench latest version

MySQL workbench On 21 Nov 2011, at 13:36, Chris Tate-Davies wrote: > What are you using to view the data? > > > > On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote: >> ;>>> 2011/11/20 20:27 +, Tompkins Neil >>>> >> Does anyon

Re: Chinese characters not displaying in Workbench latest version

What are you using to view the data? On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote: > ;>>> 2011/11/20 20:27 +, Tompkins Neil >>>> > Does anyone know why Chinese characters are not displaying correctly in a > replicated database on a slave machine ?

Re: Chinese characters not displaying in Workbench latest version

;>>> 2011/11/20 20:27 +, Tompkins Neil >>>> Does anyone know why Chinese characters are not displaying correctly in a replicated database on a slave machine ? I'm just getting square boxes. <<<<<<<< What displays them? it sounds to me as

Re: Chinese characters not displaying in Workbench latest version

- Original Message - > From: "Tompkins Neil" > > Does anyone know why Chinese characters are not displaying correctly > in a replicated database on a slave machine ? I'm just getting square > boxes. Random thought: terminal character set ? -- Bier met

Chinese characters not displaying in Workbench latest version

Does anyone know why Chinese characters are not displaying correctly in a replicated database on a slave machine ? I'm just getting square boxes. Thanks Neil

Chinese sorting and filtering on an table with charset utf-8

Hello there! I'm trying to get some software ready to work with Chinese/Hanzi characters/graphems/sinograms. My tables, using mysql 5.x, use UTF-8 for all text data. It is not an option to change that for a local Chinese installation. Storing data works quite nicely. That's w

Re: Problems inserting chinese characters

tion in which I am trying to insert some > traditional Chinese characters. The insert statement probably won't > cut and paste correctly but it is: insert into "TKTS13" values > (2,'ÄãºÃ', 'ÄãºÃ'); > > I have used this website http://people.w3. >

Problems inserting chinese characters

All, I have an application in which I am trying to insert some traditional Chinese characters. The insert statement probably won't cut and paste correctly but it is: insert into "TKTS13" values (2,'ÄãºÃ', 'ÄãºÃ'); I have used this website http://pe

MySQL 5.1 Reference Manual in Chinese

The Chinese translation of the MySQL Reference Manual is complete. It was done by one of our partners from Beijing, People's Republic of China, and covers MySQL 5.1. Due to problems beyond our control it's not available in CHM or PDF, but you can view it online, or download the HTML ver

Re: can i speak chinese?

I dunno, Can you? :) -- Peter M. Groen Open Systems Development Klipperwerf 12 2317 DZ Leiden T : +31-(0)71-5216317 M : +31-(0)6-29563390 E : [EMAIL PROTECTED] Skype : peter_m_groen > ÎҵIJÙ×÷ϵͳÊÇredhat 9.0µÄ¡£ > ÎÒÏë×°¶þ½øÖÆ°æ±¾µÄmysql 5.x > µ«ÊÇÎÒ²»ÖªµÀÄĸö°æ±¾¸üÊʺÏÎÒ¡£¡£ > ÎÒ¿´ÁËһϣ¬

can i speak chinese?

我的操作系统是redhat 9.0的。 我想装二进制版本的mysql 5.x 但是我不知道哪个版本更适合我。。 我看了一下，mysql最新的版本，有好几个？ 我把它列在了下面，有哪位兄弟可以告诉我哪个版本适合我吗？ 还有，他们都有什么区别吗？ 谢谢大家了。。 [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz 27-May

Re: Chinese order by with utf8

On 11/28/05, sheeri kritzer <[EMAIL PROTECTED]> wrote: > Hi there, > > On my system, I have the following in my show charset (I eliminated > the ones that didn't deal with chinese, so this is a partial listing)

Chinese order by with utf8

Hello: I created tables with CHARACTER SET=utf8. And stored Chinese in them. When I used SELECT * FROM ... ORDER BY ... I can't get the right order. But when I used CHARACTER SET=gbk, I can get the right order. I didn't see 'Chinese' or 'China' when SHOW COLL

Re: Chinese Characters

Can you search Chinese with mysql client (shell)? - Original Message - From: "Carol Ku" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 01, 2005 10:56 AM Subject: Chinese Characters > Hi: > I downloaded mysql 4.0 for a opensource library software called Koh

Chinese Characters

Hi: I downloaded mysql 4.0 for a opensource library software called Koha. Now I have trouble storing and searching in Chinese characters. I know that Mysql should support unicode, is there a way for me to over come this? Thank you. Carol

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

all Chinese words were turned into > unrecognized characters. Have a look here: http://dev.mysql.com/doc/mysql/en/charset-upgrading.html Chenzhou Cui wrote: > > > YL wrote: > >> Did you tried just copy those 3.23 files into a newly installed 4.1 data

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

No one can provide a perfect solution. It seems that this is really a difficult problem for the MySQL. YL wrote: I tried from 4.1 to 5.01, everything works fine without change the data files. I used Chinese in both gb and b5 (different columns in the same table) without any encoding setting

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

YL wrote: Did you tried just copy those 3.23 files into a newly installed 4.1 data folder? What's happen? Yes. I tried. The result is all Chinese words were turned into unrecognized characters. In my system, there are tens of databases, which include thousands of tables. A very

MySQL upgrade from 3.x to 4.1 for Chinese databases

Dear all, On my server there are thousands of database files contenting Chinese records. The total data volumn is over 20GB. Is there an easy way to upgrade the whole system from MySQL 3.23.x to 4.1.x? "mysqldump" is NOT a good way for me. It will be a hard and time costing w

MySQL upgrade from 3.x to 4.1 for Chinese databases

Dear all, On my server there are thousands of database files contenting Chinese records. The total data volumn is over 20GB. Is there an easy way to upgrade the whole system from MySQL 3.23.x to 4.1.x? "mysqldump" is NOT a good way for me. It will be a hard and time costing w

MySQL Chinese+ 2.0beta

I recently find a way out of mysql's chinese fulltext index bug. Moreover, I use hylanda's word segment library to optimize the fulltext performance. Any tryout is welcome and I am looking forward to your suggestion. TIA. You can download from http://www.hylanda.com/cgi-bin/download

RE: Chinese word not sort proper in 'order by'

> Â Â Â Â Âæé Â Â Â Â > Â Â Â Â Âéç > Â Â Â Â Â > Â Â Â Â Â > >but actual: > Â Â Â Â Âaxx > Â Â Â Â Âbxx > Â Â Â Â Âhhh > Â Â Â Â Âéç Â > > Â Â Â Â Â ... > Â Â Â Â Âzxx > Â Â Â Â Âæé > Â Â Â Â Âääæ > >Chinese

Chinese word not sort proper in 'order by'

普通 保丽来 Chinese GB code words are chars that their ascii values between 128-255 . Thanks ! Shuming Wang

Re: Chinese

Elim, - Alkuperäinen viesti - Lähettäjä: "Elim Qiu" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Tuesday, October 19, 2004 8:07 PM Aihe: Re: Chinese > > you can use MySQL-4.1.6 and t

Re: Chinese

> you can use MySQL-4.1.6 and the UTF-8 character >set for both Chinese and European languages. What's the default character set for MySQL 5.0.1? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Chinese

Hassan, - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, October 10, 2004 6:55 PM Subject: Chinese Hi, How do I handle Chinese text (along with regular English) in my database? I am using INNODB tables. y

Cantonese Chinese character set

I am building a site that will call up text data stored in a db by language and need to add Cantonese to the list of languages it will use. What sources would be suggested to find out what I need to do to get this to work. And I think this will be stored as a multi-byte character set. So, what

Re: where is the chinese (big5) version, windows binary distribution

Donovan Hsieh <[EMAIL PROTECTED]> wrote: >> I have the same question as posted in this thread: >> >> http://lists.mysql.com/list.php?list=mysql&post=71462 > What the problem do you have? Official binary distributions are compiled with all supported character sets. You can download windows binary

Re: where is the chinese (big5) version, windows binary distribution

I have the same question as posted in this thread: http://lists.mysql.com/list.php?list=mysql&post=71462 - Dhsieh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to show chinese in phpmyadmin

, which is very convenient and straight forward. I designed some web pages, which allow me to input data records to my database. I can type simplified Chinese and English records from a workstation into my database, and I also can retrieve those Chinese data records from an workstation's IE browse

can't use MySQL control center 0.8.7-alpha update Chinese

Hi, I can't use MySQL control center 0.8.7-alpha to insert records with fields of Chinese GB2312 characters. The updated execution result is something like "?20", I use varchar. I run it on IIS, Chinese windows2000 professtional with service pack3. But when I use consol

work with Chinese(Big5)

Hello, Wonder if anyone has experience with Chinese and mySQL. I have a column to capture chinese which is in blob. Does any one know how to write a code in Java to insert the chinese value? I am currently using mySQL version 3.23.52-max-nt. Do I need to add character-set as the manual

how to show chinese in mycc

hi,I'm new programmer using mysql , I have download mycc for mysql client, I really like it very much. But I need insert some records which have some chinese ,but in mycc I can't see any chinese (the chinese show as ??? )in the record I inserted before. I don't know how to set

Re: Chinese charset

> Is it possible to use MySQL with a chinese charset (utf8) ? You need to use BLOB or TEXT types and do a little bit of work yourself to manage them, but basically it does work fine. mySQL just treats it as binary data. -

Chinese charset

Is it possible to use MySQL with a chinese charset (utf8) ? If not, what do you suggest to do if I want to develop a database for a chinese web site ? thanks - Before posting, please check: http://www.mysql.com/manual.php

Thanks for the solution of Chinese character problem

Dear Monty, At the beginning, I missed doing the step of setting default character-set. After I have done what you said about setting default character set, the correct chinese characters are stored in mysql database. Thank you very much! Best regards, Henry. >From: Mich

Re: Chinese character error

: > Dear professional people, > > When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç > into mysql database through the mysql ODBC driver, > the original chinese characters change into another characters ¯S³¸gÀç > in mysql database. > > On the other hand, I h

Chinese character error

Dear professional people, When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç into mysql database through the mysql ODBC driver, the original chinese characters change into another characters ¯S³¸gÀç in mysql database. On the other hand, I have tried the program to

question about Chinese Windows XP and MySql

Anyone has experience with Chinese Windows Xp Professional and MySql? I am not able to install MySql on Chinese Windows. I got an unknown character error message (The package I am using is from Canada). Do I have to use the package from Asia (China, Taiwan or Hong Kong). Please advise

Re: Chinese support at MySQL

Hi Egor Egorov, If I set to big5, any influence to English data? By the way, will MySQL support UTF-8? Thanks for your help. At 20:18 02-27-2002, "Egor Egorov" wrote the following: >You should set big5 character set, look at: > http://www.mysql.com/doc/C/h/Character_sets.html -

Chinese support at MySQL

Joey, Wednesday, February 27, 2002, 3:26:26 AM, you wrote: JF> Dear all, JF> How to make MySQL with Chinese Big5 support? Thanks. You should set big5 character set, look at: http://www.mysql.com/doc/C/h/Character_sets.html -- For technical support contracts, goto

Chinese support at MySQL

Dear all, How to make MySQL with Chinese Big5 support? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

How can I get mysql to support Chinese and Japanese under win32

h9744379, Tuesday, February 12, 2002, 7:46:52 PM, you wrote: h> I want to make mysql to support Chinese and Japanese under Win2K. I have h> searched the offical manual but I could only find the section which taught h> people to configure under Linux or Unix. However, I can&#x

How can I get mysql to support Chinese and Japanese under win32

I want to make mysql to support Chinese and Japanese under Win2K. I have searched the offical manual but I could only find the section which taught people to configure under Linux or Unix. However, I can't follow it because I don't have Unix or Linux. If I want to configure it u

MySQL can not tell differences among some of the Chinese characters

ields is "name" in varchar or char type. Suppose all the names stored in the "name" are just one single Chinese character. We have following very simple queries applying on the table described as above: select * from employee where name="[a Chinese character]"; o

Re: Chinese - East Asian Languages

On Friday 26 October 2001 21:40 pm, Gerd Ruschhaupt wrote: > Hallo! > I would like to know, if Mysql works with Chinese or Japanese or > Arabic languages. > Thats all! > Thank you for your Answers. It seems to work OK with Big5 Chinese, I suspect it will work OK with GB Chines

Chinese - East Asian Languages

Hallo! I would like to know, if Mysql works with Chinese or Japanese or Arabic languages. Thats all! Thank you for your Answers. Sincerely Gerd Ruschhaupt Datahaus Publishing GmbH - Before posting, please check: http

Re: Chinese PinYin/Traditional Support in mysql?

Hi, Have you tried to change your browser's encoding to Big5 in order to view Chinese characters? Have you tried to use mysql client to select those multi-byte characters? Have you seen they are OK? If you still cannot view strings properly, and you use Java to implement your system, t

Chinese PinYin/Traditional Support in mysql?

Hi I'd like to be able to input pinyin and Big5 Chinese characters into mysql using Jive discussion forum software, e.g. I would input both English and Chinese into the same field. After reading some past postings I understand that I only need to load Chinese language support if I want

Re: simpify chinese and traditional chinese

Yes, Chinese characters isn't much of a problem. They will be stored in ASCII format unless you are using a Chinese system for your server, which should then display it as Chinese characters. Sorting isn't too much of a problem as long as sorting is done in ASCII order. I have do

Re: simpify chinese and traditional chinese

Mark Lo wrote: > Hi, > >Is it possible for mysql to store simpify and tranditional chinese. Yes, storing is not problem at all. MySQL can store any data without loss in binary fields. Problem is on sorting, upper->lower conversions and fulltext search. We do not have any chi

simpify chinese and traditional chinese

Hi, Is it possible for mysql to store simpify and tranditional chinese. Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

where is the chinese (big5) version, windows binary distribution

i need a mysql binary distribution with chinese big5 charset compiled...WINDOWS version. i have ever download an source code for windows version, but i cannot be compile as big5 version, coz there seems not has a file named "configure" might exist in Unix platform. i dont know how

Re: Storing Chinese in MySQL database

Mark Lo wrote: > I would like to know how to store chinese in MySQL Databases. What > type of column should I use ?? http://www.unicode.org/ Read up on UTF-8 -- Michael T. Babcock (PGP: 0xBE6C1895) http://www.fibrespeed.net/~mb

Re: Storing Chinese in MySQL database

Chinese OS: Read the manual on how to set the default character set and language in mysql. English OS: You will need to build a UI to be able to enter Chinese characters. Chinese characters should go in as ASCII garbage but will be displayed as Chinese characters on a Chinese OS without any

Storing Chinese in MySQL database

Hi, I would like to know how to store chinese in MySQL Databases. What type of column should I use ?? Thank You Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Chinese encoding full text index

t; > goes really slow. > > I wonder if MySQL support Chinese encoding full text index? > No. But it is in ToDo. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / /

Chinese encoding full text index

Hi! I really need a search engine that can make my users able to do a free text search in my MySQL database. I have 800 records, so a query like SELECT * FROM table WHERE content LIKE '%searchtext%' goes really slow. I wonder if MySQL support Chinese encoding full