Skip to Content

Wiki source code of UTF-8 Encoding Tips

Last modified by Ray Kiddy on 2022/01/11 21:36
Show last authors
1 = UTF-8 Encoding Tips =
2
3 Encoding questions are asked frequently on the mailing list. This is just a collection of tips for using UTF-8. It's a checklist of sorts. Make sure you've done all the things specified here before pitching your computer into the ocean
4
5 == Check your database ==
6
7 The database needs to be storing values in UTF-8. If it isn't, then all your effort is wasted. For example, on MySQL that means a db url like
8
9 {{noformat}}
10 jdbc:mysql://localhost/Example?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8
11
12 {{/noformat}}
13
14 And setting your default charset and collation in your my.cnf file
15
16 [[image:attach:options.png]]
17
18 Or you can set these things at table create as below. One can also set these on the database as a whole.
19
20
21 \\\\\\\\\\\\\\\\
22
23 {{{mysql> show create table cards \G*************************** 1. row ***************************       Table: cardsCreate Table: CREATE TABLE `cards` (  `pk` int NOT NULL,  `creator_pk` int DEFAULT NULL,  `created_date` bigint DEFAULT NULL,  `invalid_date` bigint DEFAULT NULL,  PRIMARY KEY (`pk`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci}}}
24
25 == Fonts & CSS ==
26
27 Different fonts may not have all the characters to display the different characters. If you're using a default stylesheet, then the browsers may be displaying differently simply because of fonts. Speaking of stylesheets, you probably want to encode that in UTF-8 also. Start your stylesheet with something like
28
29 {{noformat}}
30 @charset "UTF-8";
31 @import url("reset.css");
32
33 /* Begin site CSS */
34
35 {{/noformat}}
36
37 == Set eclipse encoding ==
38
39 [[image:attach:preferences.png]]
40
41 == Use Project Wonder ==
42
43 I think this goes without saying but: **Use Wonder**. Set encoding in the properties file. Notice it is UTF-8 with a hyphen. It it always UTF-8 with a hyphen... well, except with the MySQL image above because they excel in doing things differently
44
45 {{noformat}}
46 # Project Encoding
47 er.extensions.ERXApplication.DefaultEncoding=UTF-8
48
49 {{/noformat}}
50
51 == Set encoding in your page wrapper ==
52
53 {{noformat}}
54 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
55 <!DOCTYPE html PUBLIC
56 "-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN"
57 "http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg-flat.dtd">
58
59 {{/noformat}}
60
61 == Localizable strings should be in UTF-16! ==
62
63 Localizable.strings should be encoded in UTF-16. The localizer can detect UTF-16 without error, where it can confuse UTF-8 with other encodings. Specifically, you should be using UTF-16 BE with no BOM if you are using an external text editor instead of eclipse.
64
65 == Build your files in UTF-8. ==
66
67 If you have some special characters in your code (like '€' for exemple), then you will need to specify which encoding you want when you build your application. To do that, you have to modify your "build.xml" file by adding the property "encoding="utf-8" into your <wocompile> statement.
68
69 {{code language="xml"}}
70 <wocompile srcdir="Sources" destdir="bin" encoding="utf-8">
71
72 {{/code}}
73
74 (% class="auto-cursor-target" %)
75 \\