how to write file with cp1250 encodings?

Grzegorz Smith · Feb 27, 2006

Hi all. I have got situation: i load data from database(MSSQL) wchich are
encoded cp1250 and I fill template with that data (Cheetah Template), after
all i want to save template to file on disk. I'm using
newfile = open("template.html",w")
newfile.write(str(template))
newfile.close()
But data encodings are saved wrong, and I try diffrent programs to convert
but all i get was only mess. So is this any way to save data with encodings
cp1250 properly?
Any help will be very appreciated
Gregor

Waldemar Osuch · Feb 27, 2006

Grzegorz said:
Hi all. I have got situation: i load data from database(MSSQL) wchich are
encoded cp1250 and I fill template with that data (Cheetah Template), after
all i want to save template to file on disk. I'm using

One way to do it:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=cp1250" http-equiv="content-type">
<title>Welcome</title>
</head>
<body>
Welcome to $city
<br>
</body>

The idea here is to encode your unicode before passing it to the
template.

Waldemar

Magnus Lycka · Mar 1, 2006

Grzegorz said:
Hi all. I have got situation: i load data from database(MSSQL) wchich are
encoded cp1250

Are you sure that you are getting cp1250 from the database?
How do you communicate with the database? With the database
APIs I used in Windows, I always got Unicode objects from
databases, how ever things were internally stored in the DB.

If you have just managed to get your data correctly into
Unicode objects, you can convert them into whatever code
page you like with the .encode(encoding) method. Just make
sure you encode with the same encoding that yo state in
the meta element charset attribute.

jean-michel bain-cornu · Mar 3, 2006

Hi,

Grzegorz said:
Hi all. I have got situation: i load data from database(MSSQL) wchich are
encoded cp1250 and I fill template with that data (Cheetah Template), after
all i want to save template to file on disk. I'm using
newfile = open("template.html",w")
newfile.write(str(template))
newfile.close()
But data encodings are saved wrong, and I try diffrent programs to convert
but all i get was only mess. So is this any way to save data with encodings
cp1250 properly?
Any help will be very appreciated
Gregor

I had to do it recently, reading from mysql and pushing data into a
browser by cherryPy.
I used :
try:
val= dbString.decode('utf8').encode('iso-8859-1')
except UnicodeDecodeError:
val= dbString
The 'try:' was needed because of some extra-character on top of the 7
bits limit raising an exception.
I have no more explanations about that, and I must say it was a pain in
the neck to find a solution.
I guess in your case, you have to replace iso-8859-1 by something else
in the case it's not strictly the same that cp1250. The '4.9.2 Standard
Encodings' documentation section give some explanations.
Regards,
jm

read from file with mixed encodings in Python3	2	Nov 7, 2011
HOW TO WRITE A WEB SEARCH ON SCRAPY SHELL WITH ITEMS AND PIPELINES.	0	May 16, 2022
How to save textBox values into a xml-file(with naming an choosing directory)?	1	Aug 23, 2022
How to create PDF file in Batch	5	May 11, 2022
How to change key name in json file with python	0	Oct 2, 2022
How can I view / open / render / display a pdf file with c code?	0	Sep 23, 2023
Python3: Sane way to deal with broken encodings	4	Dec 6, 2009
Issue with passing fetched data to POST form. How can I?	0	Jul 23, 2023

how to write file with cp1250 encodings?

Grzegorz Smith

Waldemar Osuch

Magnus Lycka

jean-michel bain-cornu

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads