PDA

View Full Version : Currency Symbols in Results, Details and Update Pages

karen.marley367377
04-21-2009, 01:27 PM
Hi,
When inserting currency symbols such as £ or € into a data assist insert page, the results, details and update pages display them as random characters. Is there a solution to this?

The database is built in Access, and the results when edited in the database appear fine.

Many thanks for your help!
Ray Borduin
04-21-2009, 01:29 PM
Do you have a sample page... could it be the chartype of the page displaying the data?
karen.marley367377
04-21-2009, 01:44 PM
This is the char set of the page

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

This is the sort of thing that appears on the results page
Property Reference
8021277
Property Type
Retail
Sale / Lease
Sold, Subject to Contract
Region
Yorkshire & Humberside
City
York
County
Yorkshire
Summary
This is the Summary Â45 (this should be £45, and is entered using the insert page.

Price
£45000 (this pound symbol I added before the recordset)
karen.marley367377
04-21-2009, 01:46 PM
An online example of this can be found at
http://proudlysurveylinedatabase.proudlypresents.co.uk/V-Properties_search.asp
Ray Borduin
04-21-2009, 01:55 PM
I see... And if you edit and look in the database directly it seems correct as well? What is the data type for that field?
karen.marley367377
04-21-2009, 03:16 PM
When the database is added directly, the results page displays fine. It is when entered into the DA forms that the problem arises. Two of the fields are text, and the Price is numeric. Have tried using the currency format in Access for the Price field but the same problem arises.

Many thanks for your prompt replies
Ray Borduin
04-21-2009, 03:21 PM
When the database is added directly it works fine? I don't understand what would be different in that case either. Do you mean if you add a recordset to a separate page it works fine, but a recordset on this page won't display?

It must have something to do with the charset being set to utf-8. If you remove that from your header does it work?
karen.marley367377
04-23-2009, 12:39 AM
I have tried removing the character set number with the following remaining
<meta http-equiv="Content-Type" content="text/html; charset=" />

this has been removed from the insert and results page but does not work.

Any ideas?
Ray Borduin
04-23-2009, 08:24 AM
I'm at a loss. Try submitting a WebAssist support incident, maybe they will be able to spot the problem or have experience with this issue. I don't recall ever having an issue like this, maybe something in your code that would need to be debugged.
canalegrande345703
04-27-2009, 09:48 AM
Hi,
first, I'd like to know which servermodel you are using. Is it php/mysql?
In that case try to look at it with a tool like phpmyadmin and check how the language symbol was written.
UTF-8 is your friend, even if English text does not seem to need it. You'll never know in advance if there won't be words with some special characters outside the Western European scope. (like Słownik polsko-niemiecki działający także jako słownik niemiecko-polski)
In dreamweaver, check the connection string. In my case it ALWAYS helps if I put something like:

<?php
$connection = mysql_pconnect($hostname_connection, $username_connection, $password_connection) or die(mysql_error());
//after this put
$result0 = mysql_query('SET NAMES utf8');
if (!$result0) {
die('invalid request: ' . mysql_error());
}
?>