Forums / Setup & design / Encoding problem

Encoding problem

Next topic

Author	Message
Steph A	Friday 10 February 2006 5:18:37 am I have just tried to use flash applications in my ez innstallation, and for this I have to import some XML content with XML-connector in flash. The problem accured when trying to read this in flash. All special chars (norwegian) did not show as they should. The reason for this - I found out was the encoding of the templates. So I then changed template-encoding standard to UTF-8. But now the rest of my content is not showing as it should.... Is this because the encoding of my database probably is latin-1 ? What can I do?
Steph A	Saturday 11 February 2006 9:56:02 am I finally made it work! Make sure your mysql-database is set to UTF-8. Change the templates (site.ini, template.ini and i18.ini). I am also using the fck-editor, and then you also must make sure that the template literal.tpl - is encoded into UTF-8. Because this made some extra unwanted symbols in the content (two questionmarks where shown) - this is probably because the template was written with another encoding, and the data corrupted due to this conversion. Anyway, now my content is looking fine - and my flash application (with XML connector) reads the XML output just fine (with norwegian special chars.). :D

Author

Message

Friday 10 February 2006 5:18:37 am

I have just tried to use flash applications in my ez innstallation, and for this I have to import some XML content with XML-connector in flash.

The problem accured when trying to read this in flash. All special chars (norwegian) did not show as they should. The reason for this - I found out was the encoding of the templates. So I then changed template-encoding standard to UTF-8.

But now the rest of my content is not showing as it should....

Is this because the encoding of my database probably is latin-1 ?

What can I do?

Steph A

Saturday 11 February 2006 9:56:02 am

I finally made it work!

Make sure your mysql-database is set to UTF-8. Change the templates (site.ini, template.ini and i18.ini). I am also using the fck-editor, and then you also must make sure that the template literal.tpl - is encoded into UTF-8. Because this made some extra unwanted symbols in the content (two questionmarks where shown) - this is probably because the template was written with another encoding, and the data corrupted due to this conversion.

Anyway, now my content is looking fine - and my flash application (with XML connector) reads the XML output just fine (with norwegian special chars.).

eZ debug

Timing:

Jan 18 2025 11:04:37

Script start

Timing:

Jan 18 2025 11:04:37

Module start 'content'

Timing:

Jan 18 2025 11:04:37

Module end 'content'

Timing:

Jan 18 2025 11:04:37

Script end

Main resources:

Total runtime

0.6902 sec

Peak memory usage

4,096.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0091	589.0391	180.8438
Module start 'content'	0.0091	0.6749	769.8828	427.6719
Module end 'content'	0.6840	0.0061	1,197.5547	42.1328
Script end	0.6901		1,239.6875

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0091

589.0391

180.8438

Module start 'content'

0.0091

0.6749

769.8828

427.6719

Module end 'content'

0.6840

0.0061

1,197.5547

42.1328

Script end

0.6901

1,239.6875

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.4683	14	0.0002
Check MTime	0.0014	0.2063	14	0.0001
Mysql Total
Database connection	0.0013	0.1927	1	0.0013
Mysqli_queries	0.6510	94.3212	53	0.0123
Looping result	0.0004	0.0649	51	0.0000
Template Total	0.6493	94.1	2	0.3246
Template load	0.0027	0.3844	2	0.0013
Template processing	0.6466	93.6866	2	0.3233
Template load and register function	0.0002	0.0314	1	0.0002
states
state_id_array	0.0033	0.4796	1	0.0033
state_identifier_array	0.0016	0.2252	2	0.0008
Override
Cache load	0.0022	0.3209	13	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1051	1	0.0007
Fetch class attribute name	0.0010	0.1381	2	0.0005
XML
Image XML parsing	0.0001	0.0156	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0009	2	0.0000
General
dbfile	0.0028	0.4097	12	0.0002
String conversion	0.0000	0.0012	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0032

0.4683

0.0002

Check MTime

0.0014

0.2063

0.0001

Mysql Total

Database connection

0.0013

0.1927

0.0013

Mysqli_queries

0.6510

94.3212

0.0123

Looping result

0.0004

0.0649

0.0000

Template Total

0.6493

94.1

0.3246

Template load

0.0027

0.3844

0.0013

Template processing

0.6466

93.6866

0.3233

Template load and register function

0.0002

0.0314

0.0002

states

state_id_array

0.0033

0.4796

0.0033

state_identifier_array

0.0016

0.2252

0.0008

Override

Cache load

0.0022

0.3209

0.0002

Sytem overhead

Fetch class attribute can translate value

0.0007

0.1051

0.0007

Fetch class attribute name

0.0010

0.1381

0.0005

XML

Image XML parsing

0.0001

0.0156

0.0001

class_abstraction

Instantiating content class attribute

0.0000

0.0009

0.0000

General

dbfile

0.0028

0.4097

0.0002

String conversion

0.0000

0.0012

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 4

Usage

Requested template

Template

Template loaded

Edit

Override

node/view/full.tpl

full/forum_topic.tpl

extension/sevenx/design/simple/override/templates/full/forum_topic.tpl