469,914 Members | 2,184 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,914 developers. It's quick & easy.

Foreign Character Sets

Hi

Im very new to mysql - My experience of MySQL revealed some issues
with languages like Czech, Hungarian, Finnish and Polish. There was
also a question as to whether it could support Chinese.

We run version 4.0.15 of MySQL (the very latest production version is
4.0.16).

I would like to know:

1. Can it support Russian, Chinese (Reduced Character Set &
Traditional) and Spanish (not expecting a problem with Spanish)? What
standards have to be met, if any?

I saw from the official web site manual it does support these
languages. But trying to execute the command SHOW CHARACTER SET;
returns an error saying there is something wrong with the syntax.

http://www.mysql.com/doc/en/Charset-charsets.html

2. If the current implementation cannot support Chinese and Russian,
are MySQL modules available to support these languages?

3. If modules are available, what would be the cost and timescales to
have them installed? Has anyone done something similar before? As
it's open source are there any costs? Also, what would the impact be
on the implementation to support English and Arabic i.e. can they
easily be installed, would there have to be a major retesting effort?

4. I would appreciate any other input ANYONE thinks would be useful.

Many Thanks.

Thiko!
Jul 19 '05 #1
2 5003
bi*****@hotmail.com (Thiko) wrote in message news:<b8**************************@posting.google. com>...
Hi

Im very new to mysql - My experience of MySQL revealed some issues
with languages like Czech, Hungarian, Finnish and Polish. There was
also a question as to whether it could support Chinese.

We run version 4.0.15 of MySQL (the very latest production version is
4.0.16).

I would like to know:

1. Can it support Russian, Chinese (Reduced Character Set &
Traditional) and Spanish (not expecting a problem with Spanish)? What
standards have to be met, if any?

I saw from the official web site manual it does support these
languages. But trying to execute the command SHOW CHARACTER SET;
returns an error saying there is something wrong with the syntax.

http://www.mysql.com/doc/en/Charset-charsets.html

2. If the current implementation cannot support Chinese and Russian,
are MySQL modules available to support these languages?

3. If modules are available, what would be the cost and timescales to
have them installed? Has anyone done something similar before? As
it's open source are there any costs? Also, what would the impact be
on the implementation to support English and Arabic i.e. can they
easily be installed, would there have to be a major retesting effort?

4. I would appreciate any other input ANYONE thinks would be useful.

Many Thanks.

Thiko!

Hi

1. the command SHOW CHARACTER SET is supported first in version 4.1
The manual you have read is for this version
2. in your version of mysql there is russion support you must change
the character set.
Edit your /etc/my.cnf file or c:\my.cnf and add the line
default-character-set=cp1251 to [mysqld] and [mysql]
if you want to use other character set write somthing else for cp1251.
When you want to see which character set is available I think you
should check on the folder /usr/var/mysql/characters (I'm not sure for
that)
Unicode is not supported in your version of mysql.

Pozdravi Dimitar
Jul 19 '05 #2
bi*****@hotmail.com (Thiko) wrote in message news:<b8**************************@posting.google. com>...
Hi

Im very new to mysql - My experience of MySQL revealed some issues
with languages like Czech, Hungarian, Finnish and Polish. There was
also a question as to whether it could support Chinese.

We run version 4.0.15 of MySQL (the very latest production version is
4.0.16).

I would like to know:

1. Can it support Russian, Chinese (Reduced Character Set &
Traditional) and Spanish (not expecting a problem with Spanish)? What
standards have to be met, if any?

I saw from the official web site manual it does support these
languages. But trying to execute the command SHOW CHARACTER SET;
returns an error saying there is something wrong with the syntax.

http://www.mysql.com/doc/en/Charset-charsets.html

2. If the current implementation cannot support Chinese and Russian,
are MySQL modules available to support these languages?

3. If modules are available, what would be the cost and timescales to
have them installed? Has anyone done something similar before? As
it's open source are there any costs? Also, what would the impact be
on the implementation to support English and Arabic i.e. can they
easily be installed, would there have to be a major retesting effort?

4. I would appreciate any other input ANYONE thinks would be useful.

Many Thanks.

Thiko!

Hi

1. the command SHOW CHARACTER SET is supported first in version 4.1
The manual you have read is for this version
2. in your version of mysql there is russion support you must change
the character set.
Edit your /etc/my.cnf file or c:\my.cnf and add the line
default-character-set=cp1251 to [mysqld] and [mysql]
if you want to use other character set write somthing else for cp1251.
When you want to see which character set is available I think you
should check on the folder /usr/var/mysql/characters (I'm not sure for
that)
Unicode is not supported in your version of mysql.

Pozdravi Dimitar
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Thom McGrath | last post: by
reply views Thread by Thiko | last post: by
37 posts views Thread by chandy | last post: by
2 posts views Thread by Shawn Harrison | last post: by
1 post views Thread by George Woodring | last post: by
9 posts views Thread by jraul | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.