
December 22nd, 2000, 06:00 AM
|
|
Junior Member
|
|
Join Date: Dec 2000
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
I am using ActivePerl 6.18 (with DBI) and MySql 3.23.28 both on WinNT. I am facing a problem whenever I am using special characters (like ä,ö,ü or ß): I am useing a Perl-Script (started from a DOS box) to insert such values into my database. When using the mysql-client (also in a DOS box) to retrieve the data afterwards, the mentioned special characters don't appear correctly on the screen - they are only ok when I redirect the output into a file.
It is the other way round when inserting data with the mysql client: when retrieving the data with a Perl-Script (to screen and to file) the screen-output is ok but the file is wrong. Even if I retrieve it with mysql client, screen is ok but file is wrong.
I hope that anybody can help me with this problem, as I need to use those characters no matter if I use Perl or the mysql-client to handle the data.
Thank you in advance, Alex
|