try to add in the character set you need to MySQL 5.4+
http://dev.mysql.com/doc/refman/5.4/en/adding-collation-unicode-uca.html
if you cant locate the charset this means the characters you are adding are
UTF-16 characters in which case you'll need to configure UTF-16 for both mysql
and your container
personally I have i couldnt get chinese colation to work with UTF-8 or any info
is incorrect
$MYSQL_HOME/share/charsets/index.xml
<?xml version='1.0' encoding="utf-8"?>
<charsets max-id="99">
<copyright>
Copyright (C) 2003 MySQL AB
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; version 2 of the License.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
</copyright>
<description>
This file lists all of the available character sets.
To make maintaining easier please:
- keep records sorted by collation number.
- change charsets.max-id when adding a new collation.
</description>
<charset name="big5">
<family>Traditional Chinese</family>
<description>Big5 Traditional Chinese</description>
<alias>big-5</alias>
<alias>bigfive</alias>
<alias>big-five</alias>
<alias>cn-big5</alias>
<alias>csbig5</alias>
<collation name="big5_chinese_ci" id="1" order="Chinese">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="big5_bin" id="84" order="Binary">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
<..snip..>
</charset>
</charsets>
mysql> show collation like 'big5_chinese_ci';
+-----------------+---------+----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+-----------------+---------+----+---------+----------+---------+
| big5_chinese_ci | big5 | 1 | Yes | Yes | 1 |
+-----------------+---------+----+---------+----------+---------+
1 row in set (0.02 sec)
mysql> CREATE TABLE phonebook ( name VARCHAR(64), phone VARCHAR(64) CHARACTER SE
T utf8 COLLATE big5_chinese_ci);
ERROR 1253 (42000): COLLATION 'big5_chinese_ci' is not valid for CHARACTER SET '
utf8'
feel free to correct if you found a way to install big5_chinese_ci on UTF-8
Martin Gainty
______________________________________________
BTW: all these languages listed here are UTF-8 languages:
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Tue, 6 Oct 2009 10:49:41 -0700
> From: [email protected]
> Subject: Re: Struts 1: character encoding
> To: [email protected]
>
> ----- Original Message ----
> > From: senderj <[email protected]>
> > To: [email protected]
> > Sent: Tue, October 6, 2009 3:28:08 AM
> > Subject: Struts 1: character encoding
> >
> >
> > The components I use NetBean, Glassfish, Struts 1, EJB, Toplink, jdbc,
> > MySQL.
> > Basically what I want is to extract info from a web site (utf8 encoded
> > Chinese), store the info in MySQL, retrieve the info and display on my web
> > site for user to update/change it. But I got problem on the character
> > encoding. Here is briefly my logic and coding:
> >
> > (1) extract from a web page which uses UTF-8 encoded, my coding in an EJB
> > run on glassfish:
> > char c = (char) myInputStream.read();
> > Listtoken;
> > token.add((byte) c);
> > byte[] ba = new byte[token.size()];
> > for (int i=0; i
> > ba[i] = token.get(i);
> > }
> > String s = new String(ba, "UTF-8");
> >
> > I know it can be simpler, but it's a copy of others coding + my
> > amendment. But it works.
> >
> > (2) String s above is stored onto MySQL via toplink, jdbc. Table is DEFAULT
> > CHARSET=utf8. The jdbc URL is
> > jdbc:mysql://mysys:3306/testing&useUnicode=true&characterEncoding=utf-8.
> >
> > (3) Retrieve by Struts Action via EJB. Both EJB and Action does not have
> > change of string encoding. The Action put the Chinese string into a
> > DynaForm, then to JSP. JSP has <%...@page contentType="text/html"
> > pageEncoding="UTF-8"%> and it generates an html input form.
> >
> > (4) However, the Chinese characters were NOT displayed properly in the html
> > form on IE.
> >
> > (5) Anyway, in the html form, I override the incorrect Chinese character by
> > a writing pad with the correct characters (equivalent to unicode "9326
> > 6c5f") and submit. Again, no re-encoding in the Action that process the
> > update. The Action calls an EJB to update the database with the input data.
> > But I found that the database was updated with ascii string
> > "錦江" (exactly this string, not its equivalent
> > encoded).
> >
> > I feel somehow there is/are encoding changes done by the software components
> > I use (Struts? toplink? jdbc?), but don't know which one and I may be wrong.
> > If anybody has any idea on this problem please help.
> > --
> > View this message in context:
> > http://www.nabble.com/Struts-1%3A-character-encoding-tp25766281p25766281.html
> > Sent from the Struts - User mailing list archive at Nabble.com.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
>
> If you're using Tomcat and doing POST via URL, you need to change Tomcat's
> URL charset encoding. Default is ISO-8859-1, if I remember correctly.
>
> Regards,
> Tommy
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
_________________________________________________________________
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141665/direct/01/
