Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Set locale

Posted on 2010-11-16
3
Medium Priority
?
389 Views
Last Modified: 2012-05-10
I have a script that extracts data from a mysql database. I works great until I extract a text that contains danish characters like æ, ø and å.

The output looks like this:
Tilmeld dig vores nyhedsbrev og v¿r med i konkurrencen om et gavekort p¿ 25.000 kr til dit favorit indk¿bscenter!

but it should look like this:
Tilmeld dig vores nyhedsbrev og vær med i konkurrencen om et gavekort på 25.000 kr til dit favorit indkøbscenter!

The script is this one:
 
<?php
$link = mysql_connect('mysql.myserver.dk:3306', 'username', 'password');
if (!$link) {
    die('could not connect: ' . mysql_error());
}
mysql_select_db('database_bk', $link);

$my_date=date('c');
$query="select * FROM `content_type_konkurrence` WHERE '$my_date' BETWEEN `field_konk_start_value` AND `field_konk_slut_value`";
$result=mysql_query($query) or die(mysql_error());

while($row=mysql_fetch_assoc($result)) {

    echo "
<a class='konk_link' href='" . $row['field_konk_url_value'] . "'><div class='konk_div'>
<img src='http://www.mydomain.dk/files/" . $row['field_konk_billede_value'] . "' alt='" . $row['field_konk_titel_value'] . "' class='konk_billede' />
<span class='konk_tekst'><b class='konk_titel'>" . $row['field_konk_titel_value'] . "</b><br /><br />" . $row['field_konk_tekst_value'] . "</span></div></a><br />";
	
}

mysql_close($link);
?>

Open in new window


What must I do to replace those anoying ¿ with the danish characters.

Best regards
Kasper K
0
Comment
Question by:Kasper Katzmann
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
Mestika earned 2000 total points
ID: 34144648
Hi Kasper,

I am myself danish so I have dealt with this problem numerous times before. There are a lot of good articles which takes care of this subject but here are some key points.

You need to both specify your Database and your PHP code.

One thing you can start to try is to set your database to use utf8, in your php - database code:
mysql_set_charset('utf8');

like this:

mysql_set_charset('utf8');
$query="select * FROM `content_type_konkurrence` WHERE '$my_date' BETWEEN `field_konk_start_value` AND `field_konk_slut_value`";
$result=mysql_query($query) or die(mysql_error())

More, you can set the default charset in your database (assuming you use MySQL) to utf8 in your my.ini file.
0
 

Author Closing Comment

by:Kasper Katzmann
ID: 34144674
Ohh my god...

Was it that easy. I have tried with setlocale, but that didn't work at all. But you suggestion worked at once.

Thank you very much.
Jeg gi'r en øl (I buy you a beer)
0
 
LVL 3

Expert Comment

by:Mestika
ID: 34144735
Yeah it is that easy, but trust me, I created a whole method to begin with to work around the problem until I discovered how little it took to make it work.

I'm looking forward to the beer :-)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question