Blog: My Kingdom for an Umlaut (Special character fixes!)

[jstanden]

Full details on the blog:
http://www.cerb4.com/blog/2008/03/12/my-kingdom-for-an-umlaut/

[Pancho]

In german: Ein Königreich für ein Umlaut ;-)

Glückwunsch, Jeff!

Pancho

[dfroberg]

Hmmm, looks ok in the interface but funny in outlook (Notifications) if I have
AddDefaultCharset latin1 enabled.

Using AddDefaultCharset utf8 or none makes half the GUI look funny but now Outlook looks fine...

Aint developing a treat :)

[jstanden]

@Pancho: Thanks! :)

@Danny: I'll give Notifications another look real quick.

[jstanden]

Alright, give Build 565 a shot on the notification e-mails. The encoding should be forced to ISO-8859-1 (Latin1) for the time being, rather than detected as 7-bit or UTF-8.

The printable character test set I've been using is:

33 !
34 "
35 #
36 $
37 %
38 &
39 '
40 (
41 )
42 *
43 +
44 ,
45 -
46 .
47 /
48 0
49 1
50 2
51 3
52 4
53 5
54 6
55 7
56 8
57 9
58 :
59 ;
60 <
61 =
62 >
63 ?
64 @
65 A
66 B
67 C
68 D
69 E
70 F
71 G
72 H
73 I
74 J
75 K
76 L
77 M
78 N
79 O
80 P
81 Q
82 R
83 S
84 T
85 U
86 V
87 W
88 X
89 Y
90 Z
91 [
92 \
93 ]
94 ^
95 _
96 `
97 a
98 b
99 c
100 d
101 e
102 f
103 g
104 h
105 i
106 j
107 k
108 l
109 m
110 n
111 o
112 p
113 q
114 r
115 s
116 t
117 u
118 v
119 w
120 x
121 y
122 z
123 {
124 |
125 }
126 ~
161 ¡
162 ¢
163 £
164 ¤
165 ¥
166 ¦
167 §
168 ¨
169 ©
170 ª
171 «
172 ¬
173 *
174 ®
175 ¯
176 °
177 ±
178 ²
179 ³
180 ´
181 µ
182 ¶
183 ·
184 ¸
185 ¹
186 º
187 »
188 ¼
189 ½
190 ¾
191 ¿
192 À
193 Á
194 Â
195 Ã
196 Ä
197 Å
198 Æ
199 Ç
200 È
201 É
202 Ê
203 Ë
204 Ì
205 Í
206 Î
207 Ï
208 Ð
209 Ñ
210 Ò
211 Ó
212 Ô
213 Õ
214 Ö
215 ×
216 Ø
217 Ù
218 Ú
219 Û
220 Ü
221 Ý
222 Þ
223 ß
224 à
225 á
226 â
227 ã
228 ä
229 å
230 æ
231 ç
232 è
233 é
234 ê
235 ë
236 ì
237 í
238 î
239 ï
240 ð
241 ñ
242 ò
243 ó
244 ô
245 õ
246 ö
247 ÷
248 ø
249 ù
250 ú
251 û
252 ü
253 ý
254 þ
255 ÿ

[IreneF]

First: Thanks for the fix!

But I'm not sure if it really works as desired: I upgraded to rev 566.
When I add a new organisation with umlauts it is displayed correctly only after a reload of the site (which isn't a big problem.)

When creating a new ticket via "log message" with umlauts in the subject and body they are displayed like this:

öäößßßß

In contrast to the next action, which also contains umlauts and is displayed fine ...

[jstanden]

Hey Irene!

Here's what I get from Log Message with all the special characters in ISO-8859-1:
http://www.webgroupmedia.com/images/cerb4/c4_r566_logumlaut.png

What browser are you using?

Can you verify the browser is in the ISO-8859-1 charset? (Firefox is View->Character Encoding. IE is View->Encoding. Opera is View->Encoding. Safari is View->Text Encoding.)

[IreneF]

Hi Jeff,

I'm using Firefox under Fedora, the encoding is ISO-8859-1, the encoding of the mysql database is utf-8.

Irene

[dfroberg]

Jeff,
You might also want to take a peak at templates, when inserting they get the ÅÄÖ fubared like before.

[dsugita]

Jeff,
You might also want to take a peak at templates, when inserting they get the ÅÄÖ fubared like before.

Alright, just tested that on our helpdesk and saw the added chars, I let Jeff know about it. Thanks :)

[IreneF]

I'm a bit confused - there are no special characters that are displayed correctly with the latest revision. I can't test incoming mails as the issue under http://www.cerb4.com/forums/showthread.php?t=136&highlight=kerberos is still unresolved but as far as I can test replies or comments on existing tickets all umlauts are displayed like this: test: äöüß

Is that due to my server or database encoding settings or still unresolved?

Basically the kerberos-problem and the missing utf8-encoding are preventing me from moving to Cerb4.

Regards
Irene

[mfogg]

Hi Irene,

Would it be possible for you to send an email to us at support@webgroupmedia.com with your helpdesk url so we can see some debug info? If so, make sure that our ip (69.229.191.174) is permitted in your helpdesk setup, general settings.

[Pancho]

...as far as I can test replies or comments on existing tickets all umlauts are displayed like this: test: äöüß

Regards
Irene

Guten Abend Irene,

I remember that all "pre Kingdom" Umlauts remained as they were AND replies to them funnily enough too. Only tickets created after that version behaved as they should. As I am still "playing around" with Cerb4, I have no historic data to check, but just sent a mail in and replied to it:

"From: Test Support Team <service@vimus.de>
To: jfk@panacea.de
Date: Fri, 11 Apr 2008 19:31:36 +0200

ß äöüÄÖÜ


On 11.04.08/19:27, "J.F. Kunst" <jfk@panacea.de> wrote:
> ßöäü
> ÖÄÜ "

A Note, though, reads ß äöüÄÖÜ as ß äöüÄÖÜ. Comments show OK.

Immer extra Probleme mit diesen Deutschen, or Jeff? ;)

Regards
Pancho

[IreneF]

Hi Pancho!

Thanks for your reply. I just checked it and created some new tickets with the simulator, but when answering to them the umlauts are still incorret.

Schönes Wochenende :)

Irene