DLEVIET - DataLife Engine Support Home Page

DataLife Engine Support » DataLife Engine » Help (FAQ) » Need help with Unicode !!!

Need help with Unicode !!!

  • Author: invetalcom;  
  • Views: 1233;  
  • Date: 14 May 2010;  
Hello Team and Members,

I hope, somebody can help me:
My site can't display some (i think it's German) letters like: "ü, ä, ö, ß".
What do I have to change if I want the site to display these letters correctly ?
Cause the Search Clouse Module displays those letters in a strange way !!!

If this helps you; my site uses windows-1251 encoding.

Thank You
We encourage you to Register or Login to website under your name.

DjMixTape

Posted 16 May 2010 14:02 Register: 21.02.2010
I try to help, i`m not sure what u need, i don`t know dutch.

See if selected german language and see if u have good german language.
Download German DLE 8.5 HERE

I hope this will help.

invetalcom

Posted 16 May 2010 17:59 Register: 17.04.2010
What I mean is:
I got a English site, but if users enter a german letter like "ä", the "Last Search Module" displays the letter like this: "#223".
But thank you for your help

amitash

Posted 17 May 2010 00:05 Register: 13.03.2010
Change to UTF-8

parampreetinsan

Posted 17 May 2010 14:13 Register: 8.03.2010
amitash,

How To Change UTF-8?, from System Settings It Can't be changed, If u Change & save then windows-1251 is not changed to uft-8...?
feel

whisky

Posted 17 May 2010 18:40 Register: 21.03.2010
Hi invetalcom, if your site had windows-cp1251 before and you are having a lot of trouble with it, I can help you convert all database from windows-cp1251 to uft-8 and your site will be displayed letters correctly with cheap. Please contact me at rebeckydahun@live.com.
Regards :)

EaS

Posted 18 May 2010 02:38 Register: 26.03.2010
Go to phpmyadmin
Make a copy of your database
Click on your database in the left
after that change Collation to utf8_general_ci for each row you can do that if you click on each row and then Operations

also you can export and change local with a text editor that open big text files and change
CHARSET=cp1251 to CHARSET=utf8

Don't forget before you start to change make a backup of your database!

Michael

Posted 18 May 2010 20:13 Register: 14.03.2010
is there any problem if i use windows-1251


invetalcom,
i recommend you not to contact with whiskey
he will charge you money




just listen the following how to convert
Updating the site with the encoding windows-1251 to UTF-8:

If you still decide to upgrade the encoding of your site, then you should be aware that due to differences in formats, you can not just update the script and without a new installation script you can not do so to update the site, you must perform the following steps:

1. Make a backup of the database of existing site in the windows-1251
2. Perform a new installation script using the script for distribution UTF version.
3. Perform repetitive configuration script for your site.
4. Convert files to your template in UTF-8 format (for batch conversion, we recommend using a utility Sisulizer's Kaboom), When you convert uncheck "Write BOM bytes'
5. Copy the file backup of the database from your site in the folder / backup /, which you did in the first paragraph.
6. Enter adminpanel script and make the restoration of the database and adminpaneli, the script automatically detects the mismatch encodings, and in restoring the database to convert the format UTF.

Warning: Actions to transfer copyright to the encoding windows-1251 to UTF-8 are irreversible and any mistake could lead to loss of data on your site, so we urge perform these actions on the computer, and only then move everything to a working site.

invetalcom

Posted 27 May 2010 20:07 Register: 17.04.2010
Michael,
all right, thank you so much..I will give it a try

kakang

Posted 19 November 2010 18:31 Register: 11.11.2010
sorry to have wake up the old thread...I have nearly the same problem.

my site use dle 9.0 and use the cp1251_general_ci, but somehow the thread ,especially from russian federation ,give me the image like this...

hxxp://i56.tinypic.com/2vl15dw.png

how can fix this? ?
Information
Members of Guest cannot leave comments.

Popular

Pagerank Update

    Updates Yandex SEO
    04.02.2012
    23.12.2011
    09.12.2011
    Updates Yandex search
    02.02.2012
    28.01.2012
    25.01.2012
    Updates Yandex Catalogue
    03.02.2012
    02.02.2012
    01.02.2012
    Updates Google
    08.11.2011
    05.08.2011
    27.06.2011

Find us on Facebook

Poll

How do you know DataLife Engine Support?

Search Engine
Other DLE Support websites
Forum
Friends
Others

Sponsor

Calendar

«    February 2012    »
MoTuWeThFrSaSu
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29