StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5661787
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-04-14T10:21:02.140
FavoriteCount
0
LastActivityDate
2011-04-15T10:35:38.510
LastEditDate
2011-04-15T10:35:38.510
LastEditorUserId
680318
OwnerUserId
680318
ParentId
5632423
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
The Wikipedia article on UTF-8 provides a table that shows how non-ASCII characters are <a href="http://en.wikipedia.org/wiki/UTF-8#Design" rel="nofollow">encoded</a>. That table illustrates the following simple rules for UTF-8: <ul> <li>If the highest bit of a byte is 0, then the byte denotes an ASCII character.</li> <li>If the two highest bits of a byte are 11, then this is the start of a multi-byte character, and the number of consecutive 1 bits starting from the highest order bit indicates the total number of bytes in the multi-byte character. Thus, a byte whose bit representation is 110xxxxx is the start of a 2-byte character, 1110xxxx is the start of a 3-byte character, and 11110xxx is the start of a 4-byte character. (You can ignore the hypothetical 5-byte and 6-byte characters because Unicode is limited to being a 21-bit character set rather than a 32-bit character set.)</li> <li>If the two highest bits of a byte are 10, then this byte is part of a multi-byte character (but not the first byte of that character).</li> </ul> That information should be enough for you to write your own utility functions that are like <code>string.length</code> and <code>string.substring()</code> but work in terms of characters instead of bytes. Update: The question did not specify the programming language being used, and I was not aware that "Template Toolkit" implied the use of Perl. Once I realised that, I did a Google search and discovered that your problem is likely to be due to the need to add a <code>use utf8</code> directive to your source code. You can find a discussion about this <a href="http://perldoc.perl.org/utf8.html" rel="nofollow">here</a>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POTemplate Toolkit's somevar.substr() and UTF-8
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCiaran McHale
UserOwnerUserId
1. USCiaran McHale
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. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThank you for that. As you can read in the perldoc you linked `use uft8` is only for telling Perl that the *sourcecode itself* is saved in utf8. As the edit shows i already configured `Catalyst::View:TT` to use UTF-8. However, I tried to add `use uft8` to the `Catalyst::View:TT` module and it didn't help.
 singulars
 PostPostId
 PO
 UserUserId
 USDaniel Böhmer

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.