StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmysql character encoding
primarykey
Id
8196937
data
AcceptedAnswerId
8202880
AnswerCount
2
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2011-11-19T20:10:51.663
FavoriteCount
0
LastActivityDate
2011-11-20T16:22:44.677
LastEditDate
2011-11-19T20:30:34.010
LastEditorUserId
487534
OwnerUserId
487534
ParentId
0
PostTypeId
1
Score
3
ViewCount
2748
LastEditorDisplayName
text
Body
I have a MySQL server with the following settings: <pre><code>character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 </code></pre> I have a Java client that connects to this db using DBCP with this config: <pre><code> <bean id="dsJoomla" class="hu.eutrust.wsfresh.CustomDataSource"> <property name="driverClassName" value="${joomla.db.driver}"/> <property name="username" value="${joomla.db.user}"/> <property name="password" value="${joomla.db.pass}"/> <property name="url" value="${joomla.db.url}"/> <property name="connectionProperties" value="characterEncoding=UTF-8;useUnicode=true;"/> </bean> </code></pre> Then I perform somewhere in the code an update like this: <pre><code>template.update("insert into test (nev) values (:nev)", new MapSqlParameterSource("nev", "Árvíztűrő")); </code></pre> After I check the results in phpMyAdmin I see a row: <pre><code>ID NEV 2 Árvízt?r? </code></pre> The ő and ű characters that are not in the latin1 set are bad. I suppose this is because the character_set_server is latin1. But using phpMyAdmin I can manually edit the record and enter 'Árvíztűrő' and after that the record is correct. So I suppose it is possible to enter the desired value into the database with these settings. How can I do it with my Java client? How shall I configure the connection? Why do my ő and ű chars go wrong if the connection if 100% utf8? show create table test output is: <pre><code>CREATE TABLE `test` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NEV` varchar(64) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 </code></pre> show create database joomla output is: <pre><code>CREATE DATABASE `joomla` /*!40100 DEFAULT CHARACTER SET utf8 */ </code></pre>
Tags
<java><mysql><utf-8><character-encoding>
Title
mysql character encoding
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USjabal
UserOwnerUserId
1. USjabal
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POmysql character encoding
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POmysql character encoding
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POmysql character encoding
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.