473,756 Members | 8,443 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

php displays dBase table with wrong charset!

Hi!

I read an dBase table under Win XP by the common dBase functions of PHP
4.3.5.
But all records are displayd with a wrong charset.
All umlauts of the databasefile like "öäüéô"... and so on are not
displayed or are displayed in a wrong way! :-(

How can I set the correct charset for the table, that all umlauts keep save?

I thank you so much for your answer,
Lars
Jul 17 '05 #1
2 3706
DH
Goldfisch1980 wrote:
Hi!

I read an dBase table under Win XP by the common dBase functions of PHP
4.3.5.
But all records are displayd with a wrong charset.
All umlauts of the databasefile like "öäüéô"... and so on are not
displayed or are displayed in a wrong way! :-(

How can I set the correct charset for the table, that all umlauts keep
save?

I thank you so much for your answer,
Lars


You may, or may not, find helpful info here:
http://www.dbtools.com.br/EN/article.php?id=00043
Jul 17 '05 #2
You need to change the default charset that PHP uses.

(a) In your php.ini file change this line: default_charset = "UTF-8"
or
(b) In your .htaccess file set this line: php_value default_charset "UTF-8"

You must also ensure that your HTML output is UTF-8, so issue this command
before you output anything:
header('content-type:text/html; charset=UTF-8');

Hope this helps.
--
Tony Marston

http://www.tonymarston.net

"DH" <do*****@comcas t.net> wrote in message
news:dI******** ************@co mcast.com...
Goldfisch1980 wrote:
Hi!

I read an dBase table under Win XP by the common dBase functions of PHP
4.3.5.
But all records are displayd with a wrong charset.
All umlauts of the databasefile like "öäüéô"... and so on are not
displayed or are displayed in a wrong way! :-(

How can I set the correct charset for the table, that all umlauts keep
save?

I thank you so much for your answer,
Lars


You may, or may not, find helpful info here:
http://www.dbtools.com.br/EN/article.php?id=00043

Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
6153
by: Matt Young | last post by:
I've been tasked with integrating an older management system based on DBF files with my snappy new ASP application to provide users of the ASP application with real-time data from the management system. I figure with DBF files, I should use either the DBase drivers or the FoxPro drivers to connect to the database. The integration has gone quite smoothly until yesterday. This means that my connection strings work well based on the...
0
1199
by: weldonj | last post by:
I upgraded to MySQL 4.1.1-alpha-standard the other night and ever since then at least twice a day my main message board table will crash. Here's what i get when I check on the board or analyze it: check board: Table Op Msg_type Msg_text myboard.board_data check warning Table is marked as crashed myboard.board_data check error Key in wrong position at page 3072
10
7922
by: level8 | last post by:
I would like to see a Clipper/dbase DBF file as a table in SQL Server 7.0. How can I SELECT rows from DBF file? Should I use OLE DB Provider or ODBC, and how?
1
5261
by: Derek Griffiths | last post by:
Most of the complicated programs I write are boring applications that manipulate databases associated with the medical billing program where I work. The program uses foxpro dbases (version 3) for all of its' data. I'm running into a strange problem that I believe has something to do with the actual dbase file, but I couldn't find anything on google. Each group of doctors has its' own patient and billing tables. I can read the billing...
6
4132
by: Tomek | last post by:
Hi, Please help me with Data Connections into dBase files. I have catalog with lot of files like *.dbf and *.mdx . Every file contains one table (I can see it in MS Access). How can I make connections into this/that folder/files in VB.NET project? Tomek
2
3825
by: RottNKorpse | last post by:
Well I am trying to make an admin section to allow my other admins of my site able to add content to my mysql database without giving them phpmyadmin access and without teaching them out to use it as well. So I am trying to make a form that they can use to fill in a few simple fields and then it create the tables in the database and then insert a row in a seperate table that is already made. Here is how I want it to work... Name: Filename:...
3
5708
by: Dave | last post by:
I'm writing a c# Windows program that needs to be able to insert records into a dbase table. I can read it using a dataset but can't insert records. I receive the following error, ERROR Unexpected error from external database driver (15877). What is wrong?
6
3801
by: Aleyna[] | last post by:
Hi all, I wanted to connect an old DBASE file (I don't know the exact version) but I could not make it at all. I couldn't find a way to execute sql statements on db file using c#. The interesting thing my old client can connect to the database and fetch data properly. I tried all possibilities that I found on the web containing using ODBC driver and importing the data into an access file and using this file instead of working on the...
10
4781
by: Johny | last post by:
Is there a module for reading/modifing db files from Python? Thanks for help B.
0
9287
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10046
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9886
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9857
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7259
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5155
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5318
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3369
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2677
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.