Access, Central European characters, and ASP

[SoupXVII]

I have 2 problems:
1. I have a web form that accepts data in a <textarea>. Carriage returns look just fine when I display the content in an Access form. Problems start when I pull that info from Access and display it on a webpage -- CRs don't show at all. What can I do?
2. I input data to the database via ASP-powered web forms. The page is coded using the Win 1250 code page (I need Central European characters). When I open MS Access to view the data, CE characters are messed up. After I replace them in Access, they show just fine on my pages. I'm using IE 5, Access 200, and PWS for Win 98. Does anybody know a way around this? Having to upload the database every once in a while defeats the purpose of online forms...

 

[FesterSXS]

1) Replace the carriage returns with <BR> when you pull the content from the database.

eg) Replace(db_contents,vbcrlf,&quot;<BR>&quot

2) I had the same problem regarding CE characters but cant remember off-hand what I did about it - I will dig around my work and see if I can find out. Tony

http://www.phoenix-paints.co.uk/portfolio